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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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...