topic Use variables in for loop in QlikView

Use variables in for loop

mahmad — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'd like to loop over a table of values created in the data load editor, and use the values in the region to dynamically update the bolded text below. I'm not quite sure of the syntax/how to use vContent. Any help is much appreciated! Thanks.

vRegions:
LOAD * INLINE [
Region
Europe
Brazil
];

For i = 0 to NoOfRows('vRegions') - 1
let vContent = peek('Region',$(i),'vRegions') ;

Left Join (Table1)
LOAD DISTINCT
%ID,
Min([Year]) AS [Min Year Europe],
Resident Table2

Where WildMatch([Region],'*Europe*')

Group By %ID;

next i;

Re: Use variables in for loop

jonathandienst — Mon, 02 Mar 2020 04:49:24 GMT

Something like this:

For i = 0 to NoOfRows('vRegions') - 1 Let vContent = peek('Region', i, 'vRegions') ; Left Join (Table1) LOAD DISTINCT %ID, Min([Year]) AS [Min Year $(vContent)], Resident Table2 Where WildMatch([Region],'*$(vContent)*') Group By %ID; Next i

Re: Use variables in for loop

mahmad — Tue, 03 Mar 2020 00:33:34 GMT

Perfect - thanks!