5 Replies Latest reply: Nov 28, 2016 9:11 AM by Matheus Oliveira

# Left accumulated frequency

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!

• ###### Re: Left accumulated frequency

May be this

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

• ###### Re: Left accumulated frequency

Or you can try this:

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

• ###### Re: Left accumulated frequency

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

• ###### Re: Left accumulated frequency

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

• ###### Re: Left accumulated frequency

Correct! Thanks