7 Replies Latest reply: Jan 18, 2017 9:28 AM by Vasiliy Beshentsev RSS

    Hello Folks.. Need help on this on urgent basis !

    Richa Goel

      Need to create two tables in Qliksense: one with positive sales growth and other with negative sales growth like the one in the below picture. The grand total at the end of each table is represented by just selecting 'Sum' under Totals fx in the 'Sales growth' measure. This grand total is not saved in any variable. How do I retrieve this value? I have to compute % of Total Sales growth by below formula:

      % of Total Sales growth = (Sales growth for a package/Grand total) *100

      Please help in retrieving the grand total so that i can be able to compute the '% of total sales growth'.

      Capture.PNG