Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
reivax31
Partner - Creator III
Partner - Creator 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

1 Solution

Accepted Solutions
sunny_talwar

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

Generating Missing Data In QlikView

Peek() or Previous() ?

View solution in original post

4 Replies
sunny_talwar

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


talk is cheap, supply exceeds demand
Not applicable

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
Partner - Creator III
Partner - Creator III
Author

Sorry for late reply.

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