topic do loop condition in QlikView

do loop condition

Tue, 01 Jul 2014 03:57:26 GMT

Hi,

I need to know the script for my condition may be it gonna work with do loop condition

If my sales is null then the Month sould be decreased by 1 this loop should repeat until sales gets a value i.e NOTNULL

Re: do loop condition

jagan — Tue, 01 Jul 2014 04:20:15 GMT

HI,

Can you attach some sample file and expected output, it would be easier to understand.

Regards,

Jagan.

Re: Re: do loop condition

Tue, 01 Jul 2014 04:31:40 GMT

Hi jagan,

In the sample application There is a table that is done by me . but it will evaluate only for month-1 but i need it in loop until it get the value

Re: do loop condition

jagan — Tue, 01 Jul 2014 05:08:32 GMT

HI,

Can you attach some small file and come up with an example.

Regards,

Jagan.

Re: Re: do loop condition

Tue, 01 Jul 2014 05:17:55 GMT

In this example if my QTY field value is Null for that particular day it should go to previous day and take the maximum value that is present for that day, if that day also has null then it should go to previous loop ..so it is a continous loop so i need script for this condition

Re: do loop condition

jagan — Tue, 01 Jul 2014 05:25:38 GMT

Hi,

I am not getting you can you come up with an example like date, product you need to manipulate.

Regards,

Jagan.

Re: Re: do loop condition

Tue, 01 Jul 2014 05:32:29 GMT

In the above sample application in the script the if the qty field has few Null values then i need an table that should the maximum of qty according to date

QTY Date

08 1/11

2 3/11

54 3/11

0 4/11

5 5/11

Here if i select the date 3/11 the maximum value is 54 it should display 54 and if my selction is 4/11 the maximum will be 0 but if the value is 0 then it should decrease the date -1 to get a value this is done until its notnull