Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

@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

@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.