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



      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




      thanks in advance