2 Replies Latest reply: Feb 19, 2016 5:53 AM by Rémi Lépine RSS

    previous and merge cells

    Rémi Lépine

      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