topic Re: How for loop works? in App Development

How for loop works?

dineshraj — Wed, 17 Aug 2016 04:39:17 GMT

Hi all,

Could anyone explain how for loop works with simple example?

Thanks & Regards

Re: How for loop works?

Gysbert_Wassenaar — Wed, 17 Aug 2016 08:40:05 GMT

For loop - Wikipedia, the free encyclopedia

Re: How for loop works?

VishalWaghole — Wed, 17 Aug 2016 10:48:02 GMT

Loops in the Script

Hope it will help you.

Regards,

Vishal Waghole

Re: How for loop works?

ramkrishna86 — Wed, 17 Aug 2016 10:51:37 GMT

Are you asking about for loop or for each loop to load data from multiple file ?

Re: How for loop works?

dineshraj — Wed, 17 Aug 2016 11:02:39 GMT

I need explanation for both "for and for each"

Re: How for loop works?

ramkrishna86 — Wed, 17 Aug 2016 11:22:39 GMT

We use the For loop every file is sequentially loaded from the source folder and then

a preceding load is applied.

Syntax:

For each vFile in FileList

('lib://QlikSenseCookBookForEachLoadData/*.xlsx')

CountrySales:

LOAD *,Left(Source,3) as Month;

Load

Country,

Sales,

Filebasename() as Source

from [$(vFile)]

(ooxml, embedded labels, table is Sheet1);

Next vFile

Another example is:

TABLE:
load * inline
[A, B, C
China, Cotton, Shirt
India, Cotton, Socks
Japan, Leather, Jacket];

let vNOR=NoOfRows('TABLE');
for i=1 to $(vNOR)
let vA=FieldValue('A',$(i));
let vB=FieldValue('B',$(i));
let vC=FieldValue('C',$(i));

NEXT;