topic Re: for..next around a table in QlikView

for..next around a table

surajap123 — Tue, 22 Apr 2014 08:44:22 GMT

Hi All,

In the attached demo app, If you open Script editor 'orders' tab in table [Order Detail] I see the below code-

For i = 1 to 3 ...NEXT

I am wondering, what the for..next doing to the [Order Detail] table and where the i = 1 to 3 came from.

Please explain me with an example.

Thanks!!

Regards,

Suraj

MK_QSL — Tue, 22 Apr 2014 08:58:55 GMT

There could be three Worksheet in AdventureWorks.xls file

SalesOrderDetails1

SalesOrderDetails2

SalesOrderDetails3

Instead of loading three different load as below

[Order Detail]:

LOAD SalesOrderID,

SalesOrderDetailID,

...

CostAmount

FROM

[..\Database\AdventureWorks.xls]

(biff, embedded labels, table is SalesOrderDetails1)

WHERE EXISTS(SalesOrderID);

here For Next Loop is used...

When i = 1 SalesOrderDetails1

When i = 2 SalesOrderDetails2

etc..

Hope this helps...

anbu1984 — Tue, 22 Apr 2014 09:21:30 GMT