Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

Does the attached help?

Highlighted
Master
Master

Re: Ranking in Filter Panel

yes, it helped.

This expression will give you desired results.

=if(Aggr(Rank(Sum({$<[Quote Type]={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups])<=3,
Aggr(Rank(Sum({$<[Quote Type]={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups]))
&
'-'
&
If(Aggr(Rank(Sum({$<[Quote Type]={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups])<=3, [Pricing Groups], Null())

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

We're almost there Shiveshsingh!

Can we get the order right? 😬

clipboard_image_0.png

Highlighted
Master
Master

Re: Ranking in Filter Panel

Can you try putting sorting into Auto?

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

Thank you for your help on this @shiveshsingh that did the trick, however to make it perfect, i would like to remove the first " - ".  Any suggestions?

 

clipboard_image_0.png

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

I have just tried to have a go at it but couldn't work it out shiveshsingh sorry.

Attached is the sample file.

Highlighted
Master
Master

Re: Ranking in Filter Panel

No luck bro, busy in some other task.

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

Ok thanks anyway for your help man, much appreciated.

If anyone figures it out, please let me know.