Tag Archives: applymap

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

read more


QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements …

By Stefan Walther 10 Comments
Posted in Development /QV Developer, Load Scripts, QlikTips
I have recently received the question why there is no SELECT-CASE or SWITCH statement available in QlikView within load-statements. Sure, if you are looking into the reference-manual or into the help file, you’ll find the SWITCH-CASE-statement, but this is a control statement so it cannot be used within a load-statement, e.g. this is possible switch [...]

read more