Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Not possbile to suppress zero or missing values if using rank function

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Yoichi_Hirotake
Former Employee
Former Employee

Not possbile to suppress zero or missing values if using rank function

Last Update:

Jun 30, 2021 9:20:34 AM

Updated By:

Sonja_Bauernfeind

Created date:

Apr 10, 2013 2:19:25 AM

Attachments
How to suppress zero or missing values when using the rank function. 
 
Example:
 
if(rank(sum(Value),0,1)<10,1,null())
if(rank(sum(Value),0,1)<10,1,0)
 
if rank table examples.png
 

Environment:

 

Resolution:

 

The  correct way to accomplish this is to use aggr() function in the expression.
 
Please refer to following example: 

if(aggr(rank(Sum(Value),1,0),Dim)<10,1,0)


if aggr table examples.png
Labels (1)
Contributors
Version history
Last update:
‎2021-06-30 09:20 AM
Updated by: