topic Re: Check the last and previous values in column in QlikView

Check the last and previous values in column

Micki — Tue, 10 Nov 2020 09:43:47 GMT

Hi Folks,

Have a table:

I need to check if last Outcome was Not Run, then i need to avoid those rows and select Passed with ID: 3 (in that case it was the latest Passed

and final result:

To summarize i need to check based from the last outcome and select any that are not [Not Run]

Kushal_Chawda — Tue, 10 Nov 2020 10:12:24 GMT

@Micki what is the criteria to check last outcome? Is there any Date or something?

Micki — Tue, 10 Nov 2020 10:17:28 GMT

@Kushal_Chawda , by ID only, so it's like going upward, script should check if ID - Not Run then upward, until the first not - Not Run value appears

MayilVahanan — Tue, 10 Nov 2020 10:24:01 GMT

Hi @Micki

Try like below to get the Ids upto the latest Passed information

Table:
Load *, RowNo() as Row Inline
[
ID,Outcome
1,Not Run
2,Passed
3,Passed
4,Not Run
5,Not Run
6,Not Run
7,Not Run
8,Not Run
];

MaxTemp:
Load Max(Row) as MaxRow Resident Table where Outcome = 'Passed';

Let vMaxRow = Peek('MaxRow');

NoConcatenate
Load * Resident Table where Row <= $(vMaxRow);

DROP Table Table, MaxTemp;