Tag Archives: Load-Script

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

By Stefan Walther 1 Comment
Posted in Load Scripts, Macros, QlikTips

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 => [...]

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

By Stefan Walther Leave a comment
Posted in Load Scripts, QlikTips

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 [...]

A little tool for creating nested if-statements

By Stefan Walther 27 Comments
Posted in Load Scripts, QlikView-Online-Tools

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 [...]

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 [...]

QlikTip #9: Löschen von Variablen

By Stefan Walther Leave a comment
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 [...]