5 Replies Latest reply: Oct 8, 2014 8:21 AM by Tom Arne Sivertsen RSS

    Last non empty value in pivot table

      Hi All,

       

      . I have a requirement to replace nulls with previous not null value.  Can you  suggest a solution with which we can achieve
      the same

       

      Options I tried.

       

      1. Above
      function: One level is working. Failing with multiple nulls

      2. Peek
      function in script level. Fact is having 100M records. Outer join will not be a good solution

      Below link will give a clear idea on requirement

      http://community.qlik.com/docs/DOC-1304

       

      Thanks in Advance

       

      Veena