Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

reivax31
Contributor III

LOAD Merged Cell

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: LOAD Merged Cell

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

Generating Missing Data In QlikView

Peek() or Previous() ?

4 Replies
MVP
MVP

Re: LOAD Merged Cell

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

Generating Missing Data In QlikView

Peek() or Previous() ?

Re: LOAD Merged Cell

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


talk is cheap, supply exceeds demand
Not applicable

Re: LOAD Merged Cell

Hi Qlikers,

I have a problem with merged cell  and PREVIOUS. That is Excel file:

excel1.PNG

if I perform:

LOAD *,

C,

D,

if(Len(Trim(D))>0,D,Previous(D)) as D

From ...

The result in Qlik Sense is like:

EXCEL2.PNG

And the result expected is:

EXCEL3.PNG

I understand that previous command is insufficient, but I don't know which other command i can use

Thanks for your help

reivax31
Contributor III

Re: LOAD Merged Cell

Sorry for late reply.

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