Tag Archives: qvd

QlikTip #36: Loading a mapping table directly from a QVD file (QV10 SR2+)

By Stefan Walther 2 Comments
Posted in Development /QV Developer, Load Scripts, QlikTips, QlikView 10

In the past it was not possible to load a mapping table directly from a QVD file. We had to use some workarounds to break the optimized load like: Mapping_Map: Mapping LOAD Field1, Field2 FROM qvdFile.qvd (qvd) WHERE 1=1; or Mappping_Map: Mapping LOAD Field1, Field2, 1 as Field_temp FROM qvdFile.qvd (qvd); DROP FIELD Field_temp FROM [...]

QlikTip #30: How to delete existing QVD files via load-script

By Stefan Walther 4 Comments
Posted in Development /QV Developer, Load Scripts, Macros, QlikTips, Settings, Strategy

In some delta-load scenarios it may be necessary to delete specific QVD files from within your load-script (QVD-Generator). This article shows three completely different ways to achieve that goal.

QlikTip #12: Erweiterung des Store Into-Befehls in QlikView 9

By Stefan Walther 3 Comments
Posted in German Articles

STORE INTO konnte bis dato zur Speicherung einer Tabelle in eine QVD-Datei verwendet werden. // Store table Customers into Qvd-file STORE Customers INTO Customers.qvd (qvd); Dabei ist (auch in vorherigen Versionen) der Parameter nach dem Dateinamen, als “(qvd)” optional, wenn man diesen weglässt, dann funktioniert das Speichern in QVD-Dateien trotzdem. Wozu dieser zusätzliche Parameter (auch [...]