# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for
Did you mean:
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
Contributor III
Author

Does the attached help?

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())

Contributor III
Author

We're almost there Shiveshsingh!

Can we get the order right? 😬

Master

Can you try putting sorting into Auto?

Contributor III
Author

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?

Contributor III
Author

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

Attached is the sample file.

Master

No luck bro, busy in some other task.

Contributor III
Author

Ok thanks anyway for your help man, much appreciated.

If anyone figures it out, please let me know.