Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Count of cumulative

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:-)

2 Replies
miguelbraga
Valued Contributor III

Re: Count of cumulative

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

Not applicable

Re: Count of cumulative

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.