topic Re: for loop in QlikView

for loop

Tue, 18 Aug 2015 03:09:27 GMT

hi all,

i have excel with three sheets named sheet1,sheet2,sheet3

i want load those three sheets into qlikview using for loop and

2.i have different excel files dat1,dat2,dat3 how can i load using for loop plz help me with example

thanks

senpradip007 — Tue, 18 Aug 2015 04:24:12 GMT

Try like:

for i = 1 to 3

for j = 1 to 3

Tab:

LOAD 'Dat'&$(i)&'-'&'Sheet'&$(j) as Source,

F1,

FROM

(ooxml, embedded labels, table is Sheet$(j));

qlikviewwizard — Tue, 18 Aug 2015 05:11:16 GMT

Hi please check this thread.

qlikviewwizard — Tue, 18 Aug 2015 05:12:58 GMT

Try these links