Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Paula1
Creator
Creator

Accumulate the Rank values

Cod Store Rank
     
17459 382.866,50 9,00%
5277 315.619,78 7,42%
19197 73.198,66 1,72%
24542 66.645,75 1,57%
23283 62.226,76 1,46%
I need to accumulate Rank like the example below.
set analysis
Cod  Store Rank
accumulated
  4.252.486,56 100,00%  
17459 382.866,50 9,00% 9,00%
5277 315.619,78 7,42% 16,43%
19197 73.198,66 1,72% 18,15%
24542 66.645,75 1,57% 19,71%
23283 62.226,76 1,46% 21,18%

 

Paula Santos
vitória - ES
Labels (3)
2 Solutions

Accepted Solutions
Kushal_Chawda
MVP
MVP

@Paula1  is the Rank expression ? If so what is expression?

View solution in original post

vinieme12
Champion III
Champion III

As below

=Rangesum( Above( Aggr (
<EXPRESSION FOR RANK>
,COD),0,rowno()))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
Kushal_Chawda
MVP
MVP

@Paula1  is the Rank expression ? If so what is expression?

vinieme12
Champion III
Champion III

As below

=Rangesum( Above( Aggr (
<EXPRESSION FOR RANK>
,COD),0,rowno()))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.