Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

previous and merge cells

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

1 Solution

Accepted Solutions
MVP
MVP

Re: previous and merge cells

Can you try this:

LOAD *,

          C,

          If(Len(Trim(D))>0, D, Peek('D')) as D

From ...

2 Replies
MVP
MVP

Re: previous and merge cells

Can you try this:

LOAD *,

          C,

          If(Len(Trim(D))>0, D, Peek('D')) as D

From ...

Not applicable

Re: previous and merge cells

Thank you Sunny,

I can also  use some imbricate previous, as this:

if(len(trim(Previous(.....

          if(len(trim(Previous(previous(......

              if(len(trim(Previous(previous(previous(.....

                    etc..