topic FOR-loops, STORE and dynamic file names. in QlikView

FOR-loops, STORE and dynamic file names.

Wed, 17 Nov 2010 14:36:08 GMT

Hi!

I have a question regarding FOR-loops. I want to, in my script, basically iterate through my Date-field and save my Articlenumber and Inventoryvalue (fields) for that date into seperate qvd-files for each date

Anyone got any example of this?

Thanks!

FOR-loops, STORE and dynamic file names.

Miguel_Angel_Baeyens — Wed, 17 Nov 2010 22:42:06 GMT

Hello,

It should look like the following

PossibleValues:LOAD CONCAT(Date, chr(39) & ', ' & chr(39)) AS AllDatesRESIDENT Sales; LET vPossibleDates = chr(39) & Peek('AllDates', 0) & chr(39); FOR EACH vDate IN $(vPossibleDates) Temp: NOCONCATENATE LOAD * RESIDENT Sales WHERE Date = '$(vDate)'; STORE Temp INTO File_$(vDate).qvd; DROP TABLE Temp; NEXT

Please take into account that loops are very slow and would result in poor performance and longer loading scripts.

Hope this helps

FOR-loops, STORE and dynamic file names.

Thu, 18 Nov 2010 20:24:39 GMT

I found a similar way to yours that did it bu´t your idea works too, thanks!