Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Accumulative percentage

Hello I'm trying to get a column that returns the accumulative percentage of the frequency columns but the expression is returning a percentage but not the accumulative percentage.  

 

=Rangesum(Above(sum(Frequency),0,rowNo()))/sum(TOTAL Frequency)

4 Replies
Highlighted
Partner
Partner

Re: Accumulative percentage

the expression looks correct.
are you using this in a stright table?
can you share some sample data and show whats the output you are getting.
Highlighted
Contributor III
Contributor III

Re: Accumulative percentage

I converted it to a pivot table and when I did my expression did work.  Is there a way to do this in a straight table?  Thanks.  

Highlighted
Partner
Partner

Re: Accumulative percentage

Hi Dleota,

Try this:

Rangesum(Above(TOTAL Sum(Frequency),0,RowNo())) / Sum(TOTAL Frequency)

Jordy

Climber 

Work smarter, not harder
Highlighted
Partner
Partner

Re: Accumulative percentage

use total qualifier in above as well. 

You may need to do total <dimensions> if you want to exclude some