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:
Some days ago I received a funny/tricky question:
Let’s assume you have the following data:
In some delta-load scenarios it may be necessary to delete specific QVD files from within your load-script (QVD-Generator).
There are three different options for deleting variables in QlikView:
In the last three years I have quite often changed my standard concept of structuring my (customers’) QlikView projects in the file system.
If you want to load all fields in a table or a QVD file in loading scripts (so typically SELECT * FROM... scenarios), it is often necessary to k
SELECT * FROM...
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.
I have recently received the question why there is no SELECT-CASE or SWITCH statement available in QlikView within load-statements.
Nested If-statements are sometimes necessary in QlikView- load-scripts, unfortunately.