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

Ranking in Filter Panel

Hi all,

Is there away to add the ranking before the Pricing Groups in the following expression?

Example:

1 - Pricing group A

2 -Pricing group D

3 -Pricing group C

=If(Aggr(Rank(Sum({$<SQType={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups])<=3, [Pricing Groups], Null())

17 Replies
Highlighted
Contributor III
Contributor III

Does the attached help?

Highlighted
Master
Master

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

We're almost there Shiveshsingh!

Can we get the order right? 😬

clipboard_image_0.png

Highlighted
Master
Master

Can you try putting sorting into Auto?

Highlighted
Contributor III
Contributor III

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

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

No luck bro, busy in some other task.

Highlighted
Contributor III
Contributor III

Ok thanks anyway for your help man, much appreciated.

If anyone figures it out, please let me know.