topic Re: Peek vs Previous in QlikView

Peek vs Previous

demoustier — Fri, 13 Feb 2015 15:32:28 GMT

Hi,

Do anybody have an idea to solve this very simple problem:

I have loaded a table like this:

For each value of 'key' I can have 0 to n value of INV and/or PO

I'd like to fill in missing value of PO with PO value having same key

result should be:

I tried with if(key=previous(key) and isnull(PO),previous(PO),PO) as PO2 but it works only for one line....

Any idea ?

Kind regards

Fri, 13 Feb 2015 15:38:51 GMT

Try like below:

IF( IsNull(PO) AND key=Previous(key) , Peek(PO2) , PO ) AS PO2

Previous -- Loaded from previous loaded table

Peek -- Loaded from current table

demoustier — Fri, 13 Feb 2015 15:51:22 GMT

hey !

it seems good !!!!

it perfectly works with the example but not in my application ?! Anyway, i will work on this way

Thanks !!!!!!