Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

In QV i can just click on full Accumulation. In QS , may i know how to do it ?

Hi All

I am create a 8020 table.

My expression :-

Sum(sales)/Sum(TOTAL(sales))

Paul

4 Replies
paulyeo11
Master
Master
Author

my qvf

sunny_talwar

May be just this

RangeSum(Above(Sum(sales), 0, RowNo()))/Sum(TOTAL sales)

sunny_talwar

or this: RangeSum(Above(TOTAL Sum(sales), 0, RowNo(TOTAL)))/Sum(TOTAL sales)

Something like attached?

paulyeo11
Master
Master
Author

Hi Sunny

Now your name added Talwar !

Your expression work fine. But After i have use your expression , My table unable to sort from Hi to Lo on sales SUM ?

Paul