topic Re: create a flag using loop and peek in QlikView

create a flag using loop and peek

markgraham123 — Tue, 18 Jul 2017 18:19:49 GMT

Hi all,

I'm trying to create a new flag by looking at the previous record it has.

Can someon please help?

Any help is highly appreciated.

Please see the attachemnt

markgraham123 — Tue, 18 Jul 2017 18:21:13 GMT

Any inputs brother?

sunny_talwar — Tue, 18 Jul 2017 18:25:25 GMT

May be this

Table_Temp:

LOAD * Inline

[

Time, Flag, Req. output

1, null, null

2, y, y

3, null, y

4, null, y

5, null, y

6, N, N

7, null, N

];

Table_Final:

LOAD *,

If(Len(Trim(Previous(Flag))) > 0 and Flag = 'null', Peek('Req Flag'), Flag) as [Req Flag]

Resident Table_Temp

Order By Time;

DROP Table Table_Temp;

markgraham123 — Tue, 18 Jul 2017 18:32:21 GMT

Thank you Brother!!

So, when we say, Flag='Null', then use peek, it keep sskipping till the filed is not 'null' and it finds any other value ??

Please correct if i'm wrong.

sunny_talwar — Tue, 18 Jul 2017 18:50:45 GMT

Yes...