Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have a problem with merged cell in a Excel file:
if I perform:
LOAD
A,
B,
C
From ...
The result in Qlik Sense is like:
How can I avoid the empty cells?
Thanks for your help
Try using Peek()/Previous() functions to fill the missing data.
Try using Peek()/Previous() functions to fill the missing data.
You can use the peek function to fill the empty cells:
LOAD
A,
B,
If(Len(Trim(C))>0,C,peek(C)) as C
FROM
...excel_file...
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
Sorry for late reply.
Thanks for your help again. It worked with previous() !