2 Replies Latest reply: May 22, 2018 1:56 AM by Gulshan Rohilla RSS

    Before function in QlikSense Pivot table

    Gulshan Rohilla

      Hello everyone,

       

      I want the below report in QlikSense

      query.PNG

       

      the upto total section is adding the current and before value in the column and I have achieved some part of it. I somehow managed to add the previous into current but the first value appears null and addition starts from second and also i am not able to convert the null values into zeroes. can anyone tell me how to do that. below is my attached screenshot

      q1.PNG

      q2.PNG

       

      thanks in advance