Discussion board where members can get started with Qlik Sense.
I have a problem with merged cell in a Excel file:
if I perform:
The result in Qlik Sense is like:
How can I avoid the empty cells?
Thanks for your help
Go to Solution.
Try using Peek()/Previous() functions to fill the missing data.
Generating Missing Data In QlikView
Peek() or Previous() ?
You can use the peek function to fill the empty cells:
If(Len(Trim(C))>0,C,peek(C)) as C
I have a problem with merged cell and PREVIOUS. That is Excel file:
if(Len(Trim(D))>0,D,Previous(D)) as D
And the result expected is:
I understand that previous command is insufficient, but I don't know which other command i can use
Sorry for late reply.
Thanks for your help again. It worked with previous() !