topic Simplify code in load statements in QlikView

Simplify code in load statements

Fri, 20 Nov 2009 00:29:54 GMT

I have some very long formulas within a Load Statement and some of the fields depend on the value of the field above.

Rather than nest the code for the line above in the new line which gets difficult to read is there a way to define a variable within the load or another way to simplify it?

Simplify code in load statements

johnw — Fri, 20 Nov 2009 00:50:50 GMT

You can use preceeding loads to load from the table so far and add fields based on other fields. For a simple example:

[Something]:
LOAD *
,if("Category"='A' and "Month"=date(20090501,'YYYYMMDD'),"Amount") as "May 09 Category A Amount"
;
LOAD *
,date(monthstart("Date")) as "Month"
;
LOAD
date(date#(20081231,'YYYYMMDD')+recno()) as "Date"
,mid('ABCDE',ceil(rand()*5),1) as "Category"
,ceil(rand()*1000) as "Amount"
AUTOGENERATE today()-date#(20081231,'YYYYMMDD')
;

Simplify code in load statements

Fri, 20 Nov 2009 16:27:13 GMT

Thank you - very helpful