Tag Archives: Load-Script

QlikTip #9: Deleting variables via user-interface, within the load-script or by using macros (translated)

By Stefan Walther Comments closed
Posted in QlikTips, Load Scripts, Macros
There are three different options for deleting variables in QlikView: Deleting using the “Variable Overview” Deleting within the load-script Deleting using macros Option 1: Deleting using the “Variable Overview” For deleting a variable using the “Variable Overview” within the windows client just follow the steps below: Call the “Variable Overview” dialog (Menu => Settings => […]

read more


QlikTip #23: Deleting fields within a load-script dynamically

By Stefan Walther Comments closed
Posted in QlikTips, Load Scripts
Some days ago I was asked how one could delete fields dynamically within/after a load-script in QlikView based on the name of the field/column. So all columns for example with a prefix “F_” should be deleted after loading all tables from a database. My first response was, that the “Table functions” (please have a look […]

read more


A little tool for creating nested if-statements

By Stefan Walther Comments closed
Posted in QlikView-Online-Tools, Load Scripts
Nested If-statements are sometimes necessary in QlikView- load-scripts, unfortunately. They are quite difficult to read and very tricky to create and especially to debug. In the last recent months I had a lot of projects where a tenfold nesting of if-statements was not uncommon. After struggling with these nested ifs for a while I decided […]

read more


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

By Stefan Walther Comments closed
Posted in German Articles
STORE INTO konnte bis dato zur Speicherung einer Tabelle in eine QVD-Datei verwendet werden. [qvl] // Store table Customers into Qvd-file STORE Customers INTO Customers.qvd (qvd); [/qvl] 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 […]

read more


QlikTip #9: Loeschen von Variablen

By Stefan Walther Comments closed
Posted in German Articles
Variablen können in Qlikview auf drei Varianten gelöscht werden: Löschen über die Benutzeroberfläche/den Windows Client Löschen im Load-Script Löschen mit einem Makro  Variante 1: Löschen über den Windows-Client Das Löschen über die Benutzeroberfläche erfolgt über folgende Schritte Menü -> Einstellungen -> Variablenliste (oder gleich Ctrl/Strg + Alt + V) dann im Dialog eine Variable auswählen […]

read more