previous and merge cells

[#1]

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

[sunny_talwar · Accepted solution]

Can you try this:

LOAD *,

          C,

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

From ...

[#3]

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