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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with rank function please

I want to prepare a chart with different ranks for one selected client (CMU2_NM)

CMU2_NM is not part of dimension. Chart dimension is - CALENDAR_PERIOD since the ranks are needed for different periods. 4 possible values for CALENDAR_PERIOD are loaded using inline load.

Added below expression for the chart -

=if(CALENDAR_PERIOD='YTD 2011',

Aggr(rank(sum({<CMU2_NM={"*"}>}F_CV_YTD)),CMU2_NM),

if(CALENDAR_PERIOD='YTD 2010',

Aggr(rank(sum({<CMU2_NM={"*"}>}F_CV_PREV_YTD)),CMU2_NM)))

Now the problem is only first rank YTD 2011 is displayed... other ranks are not displayed and instead it shows "-". Please refer to attached image..

Can someone help please to fix above expression...

1 Reply
Not applicable
Author

Bump!

Appreciate if someone can point me in a right direction to fix this...