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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get top 5 ranking diemensions in string format

ChannelSalesBrandDept
Channel11235SamsungPhone
Channel2354BlackberryPDA
Channel3941OppoPhone
Channel4341NokiaPhone
Channel5924SansuiPhone
Channel61733ToshibaTV
Channel71460ApplePhone
Channel81177MicromaxTV
Channel91719Le10Phone
Channel10917MaximaWatch
Channel31585ApplePhone
Channel41828MicromaxTablet
Channel5689Le10Phone
Channel61364SansuiPhone
Channel71774ToshibaTV
Channel8232ApplePhone
Channel91093MicromaxPhone
Channel101677Le10Phone
Channel1375MaximaPhone
Channel21579Le10Phone

Hi I want to have the saleswise top 5 channels in text or string format not in number format .

I have tried

for first ranked channel - Aggr(if(Rank(Sum(Sales))=1,Channel),Channel)

similarly for second , third , fourth and fifth i have used 2,3,4,5 but this is returning me in number format.


Actually I need to feed this as an input to a set analysis where condition so it is important that this is in text or string format. Please provide any pointers.  


10 Replies
swuehl
MVP
MVP

And the expression editor shows an explicite error message?

The advanced search will not be evaluated and interpreted by the syntax checker, so I think you shouldn't be worried by the coloring alone.