7 Replies Latest reply: Feb 29, 2016 10:59 AM by Sangram Reddy RSS

    Cumulative chart and color coding for calculated measures

    rodolphe moreau

      Hi,

       

      I am a new user of Qliksense and I have 2 questions:

       

      Question 1:

      I am trying to do chart showing cumulative volume and cumulative Gross Margin (see below)

      Any advise for the expression (formula for cumulative data) and the chart to be used (line chart)???

       

      Question 2:

      I have a pivot table with Gross Margin per Liter (Gross Margin divided by Liter). I would like negative value to be in red. I would like to know the formula to add color in Text color expression...

       

      Thank you in advance for your help

       

      Best regards,

      Rodolphe