
Re: Cumulative chart and color coding for calculated measures
Muliady Hartono Feb 28, 2016 8:01 PM (in response to rodolphe moreau)Hi Rodolphe,
Answer #1: Will an adaptation of the article by HIC below work?
Qlik Design Blog : Recipe for a Pareto Analysis  Qlik Community
Answer #2: will the below color expression work?

Re: Cumulative chart and color coding for calculated measures
Phaneendra Kunche Feb 28, 2016 2:07 AM (in response to rodolphe moreau)#1: use Rangesum & Above functions with a Line chart
RangeSum(Above(GROSS_MARGIN_EXPRESSION,0,RowNo()))
#2: Muliady Hartono solution should work.

Re: Cumulative chart and color coding for calculated measures
rodolphe moreau Feb 29, 2016 7:48 AM (in response to Phaneendra Kunche )Thank you
#1: It works for the measure but not for the dimension because a line chart requires a dimension and a measure
When I chose the expression RangeSum(Above(GROSS_MARGIN_EXPRESSION,0,RowNo())) in the dimension field, I got the error message : Invalid Dimension. May be a line chart does not support the Cumulative formula for the Y and X axis.
#2 color coding works for a not calculated measure (Gross Profit), not for a calculated measure (Gross Margin per Liter)
Any suggestion?
Regards,
Rodolphe


Re: Cumulative chart and color coding for calculated measures
Sangram Reddy Feb 29, 2016 8:46 AM (in response to rodolphe moreau)Hi Rodolphe,
For the first question, I am assuming that you are looking for something like this:
if((sum([Days In Stock]) / count([Vehicle ID])) < 35,rgb(146,208,80),rgb(255,0,0))
And for the second question make use of an expression similar to this:
if((sum([Current Stock Budget])sum([Stock Value])>0),rgb(146,208,80),rgb(255,0,0))
Thanks,
Sangram.

Re: Cumulative chart and color coding for calculated measures
rodolphe moreau Feb 29, 2016 9:19 AM (in response to Sangram Reddy)thanks  #2 is now OK
for the first question I think this is not possible in Qliksense to make a line chart with 2 measures (1 for X axis and 1 for Y axis). Line charts in Qliksense only allow 1 dimension and 1 measure. Will you agree with me?

Re: Cumulative chart and color coding for calculated measures
Sangram Reddy Feb 29, 2016 10:58 AM (in response to rodolphe moreau) 
Re: Cumulative chart and color coding for calculated measures
Sangram Reddy Feb 29, 2016 10:59 AM (in response to rodolphe moreau)Though you have a restriction of 2 dim 1 measure / 1 dim 2 measures, using the pick() function you can implement multi line line chart

