Count of cumulative

[#1]

I have an expression for cumulative value for my top 10 rootcause. i want to take the count of cumalative value for one particular condition. Can anyone help me with this. Thank you:-)

[miguelbraga]

Hey there,

Have you tried using RangeSum expression?

See here:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/ChartFunctions/RangeFunctions/rangesum....

Best regards,

Data Architect MB

[#3]

Hi Miguel,

Yeah. I am using the below expression for cumulative value.

cumulative=

RangeSum(Above(Sum(aggr(count(MT_ID),[Issue Type],[Request Type])),0,RowNo()))/

sum(TOTAL Aggr(Count(MT_ID),[Issue Type],[Request Type])) and I am taking the top 10 by setting the max value in the presentation. Now, I want the count of Cumulative for values more than 80% to be displayed in the label of my chart.