Left accumulated frequency

[#1]

Hi!

I'm trying to make a left cumulative graph on qliksense to count all items with score greater than X.

This code counts the correct items: sum(if(erp_department_compare='True',1,0). How to get, for each score X, a sum of all items with the score greater than X?

Thanks!

[sunny_talwar]

May be this

RangeSum(Above(Sum(If(erp_department_compare = 'True',1, 0)), 0, RowNo()))

[sunny_talwar]

Or you can try this:

RangeSum(Above(Sum({<erp_department_compare = {'True'}>} 1), 0, RowNo()))

[#4]

This corresponds to a right cumulative. I need the opposite. Thanks!

[sunny_talwar · Accepted solution]

May be this (not 100% confident):

Sum(TOTAL If(erp_department_compare = 'True',1, 0)) - RangeSum(Above(Sum(If(erp_department_compare = 'True',1, 0)), 0, RowNo()))

[#6]

Correct! Thanks