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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-08-01 03:22 AM

IF (aggr(rank( sum(Value) ,0) , Value )> 5 , sum(Value) )

explination pls  how it is working 

IF (aggr(rank( sum(Value) ,0) , Value )> 5 , sum(Value) )     

499 Views
0 Likes
1 Reply
Not applicable
‎2014-08-01 03:54 AM
Author

IF (aggr(rank( sum(Value) ,0) , AnyDimension)> 5 , sum(Value) )    


It makes the sum of value only if its rank (of the sum(Value) aggregated for AnyDimension) is >5 (ex. 6th,7th,...)

291 Views