LOAD Merged Cell

[reivax31]

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

[sunny_talwar · Accepted solution]

Try using Peek()/Previous() functions to fill the missing data.

Generating Missing Data In QlikView

Peek() or Previous() ?

[Gysbert_Wassenaar]

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...

[#4]

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

[reivax31]

Sorry for late reply.

Thanks for your help again. It worked with previous() !