Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Fabien
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
Fabien
Contributor III
Contributor III
Author

Does the attached help?

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

Fabien
Contributor III
Contributor III
Author

We're almost there Shiveshsingh!

Can we get the order right? 😬

clipboard_image_0.png

shiveshsingh
Master
Master

Can you try putting sorting into Auto?

Fabien
Contributor III
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?

 

clipboard_image_0.png

Fabien
Contributor III
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.

shiveshsingh
Master
Master

No luck bro, busy in some other task.

Fabien
Contributor III
Contributor III
Author

Ok thanks anyway for your help man, much appreciated.

If anyone figures it out, please let me know.