4 Replies Latest reply: Oct 12, 2017 6:09 PM by Maria Sandorova RSS

    Handel missing values in qliksense

    Rakesh Pareek

      Hi,

       

      I am creating pivot table in qliksense. Below is my sample data:

       

      RACCT

      Segment

      Amount

      1000000

      Lead

      1

      1000010

      Buildestate

      1

      1001000

      Aluminium

      1

      1001010

      Lead

      1

      1002000

      Aluminium

      1

      1003000

      Lead

      1

      1004000

      Aluminium

      1

      1005000

      Aluminium

      1

       

      I have attached the screenshot of current output.

       

      But I require below-mentioned output:

       

      RACCT

      Segment

      Aluminium

      Buildestate

      Lead

      1000000

      0

      0

      1

      1000010

      0

      1

      0

      1001000

      1

      1

      0

      1001010

      0

      0

      1

      1002000

      1

      1

      0

      1003000

      0

      0

      1

      1004000

      1

      1

      0

      1005000

      1

      1

      0

       

      I want 0 at the place of missing values in table.


      I have tried isnullnumsum, rangesum, len and alt functions.

       

      Kindly suggest.