Discussion Board for collaboration on QlikView Scripting.
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 ?
Go to Solution.
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
it seems good !!!!
it perfectly works with the example but not in my application ?! Anyway, i will work on this way