Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.