Discussion board where members can get started with Qlik Sense.
I have a problem with merged cell and PREVIOUS. That is Excel file:
if I perform:
if(Len(Trim(D))>0,D,Previous(D)) as D
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
Go to Solution.
Can you try this:
If(Len(Trim(D))>0, D, Peek('D')) as D
Thank you Sunny,
I can also use some imbricate previous, as this: