Discussion board where members can get started with Qlik Sense.
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.
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.
Rangesum(Above(TOTAL Sum(Frequency),0,RowNo())) / Sum(TOTAL Frequency)
use total qualifier in above as well.
You may need to do total <dimensions> if you want to exclude some