RSS-Feeds & Newsletter
Category Archives: Development /QV Developer
QlikTip #9: Deleting variables via user-interface, within the load-script or by using macros (translated)
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 #25: How do you organize your QlikView projects in your file system?
In the last three years I have quite often changed my standard concept of structuring my (customers’) QlikView projects in the file system. But for about 1 1/2 years “my” concept seems to be stable : Some hints: In 0_Scripts all included scripts are saved 1_Resources includes all Excel-files, settings files and other resources (eg. [...]
QlikTip #15: Changing the layout-raster in QlikView’s design mode (translated)
While designing your QlikView application it is quite useful to enable the design-mode and at the same time the design-grid (Ctrl+G or Menu => View => Design Grid). This is very useful to align the objects within the user interface. Personally I prefer to work with a smaller raster: This setting can be found (saved [...]
QlikTip #3: Check whether a field exists or not (translated and improved)
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 know whether a field (within a table) exists or not. The following code example demonstrates how this can be achieved: Customers: LOAD * INLINE [ CustomerId, PostalCode, [...]
QlikTip #23: Deleting fields within a load-script dynamically
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 [...]
QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements …
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 [...]
Stefan WALTHER
QlikTip #30: How to delete existing QVD files via load-script
Also posted in Load Scripts, Macros, QlikTips, Settings, Strategy