Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have a problem with merged cell and PREVIOUS. That is Excel file:
if I perform:
LOAD *,
C,
D,
if(Len(Trim(D))>0,D,Previous(D)) as D
From ...
The result in Qlik Sense is like:
And the result expected is:
I understand that previous command is insufficient, but I don't know which other command i can use
Thanks for your help
Can you try this:
LOAD *,
C,
If(Len(Trim(D))>0, D, Peek('D')) as D
From ...
Can you try this:
LOAD *,
C,
If(Len(Trim(D))>0, D, Peek('D')) as D
From ...
Thank you Sunny,
I can also use some imbricate previous, as this:
if(len(trim(Previous(.....
if(len(trim(Previous(previous(......
if(len(trim(Previous(previous(previous(.....
etc..