topic Re: Use while and where in loading script in QlikView

Use while and where in loading script

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

I have the follwing script

AsOfMonth:

load 'Current' as Type,

Month as Month_AsOf,

Month as Month

Resident SalesData;

Concatenate (AsOfMonth)

load 'Rolling 3' as Type,

Month as Month_AsOf,

Month + 1 - IterNo() as Month

Resident SalesData

where promo =1

while IterNo() <= 3//here my problem

;

How to correct it ?

avinashelite — Thu, 03 Mar 2016 12:48:56 GMT

try like this

while (IterNo() <= 3 and promo =1) ;

swuehl — Thu, 03 Mar 2016 12:49:22 GMT

I think you can either use a WHERE or a WHILE clause in the same LOAD statement.

If you want to use both clauses, you would need separate / preceding LOAD statements.