Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
shiveshsingh
Master
Master

May be you can append rank before like this

 

= Rank(Field) & '-' & Your Current expression

Fabien
Contributor III
Contributor III
Author

Thanks for your response Shivesh, however it does not seem to work...

This is what i tried:

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

shiveshsingh
Master
Master

Hi

By Rank(Field) i meant to say, You have to put the expression or Column name in place of Field basis on which your Rank is calculated.

May be this expression or something - =Rank(Sum({$<SQType={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU))

Fabien
Contributor III
Contributor III
Author

Hi,

Unfortunately it did not do the trick...

I am struggling with it considering the length of the expression and am not sure what element should be the field.

Could the issue be that i already have an Rank() in my original expression?

shiveshsingh
Master
Master

Ok, what is the logic for these numbers? 1,2,3?

Fabien
Contributor III
Contributor III
Author

They are purely to list up the top 3 so not very important, but i still would have liked to see them there..

shiveshsingh
Master
Master

Can you try this?

RowNo() & '-' &Your expression

Fabien
Contributor III
Contributor III
Author

Unfortunately it did not do the trick:

Screenshot - 23_08_2019 , 9_20_21 AM.png

shiveshsingh
Master
Master

Cool , I missed that it has to be done in dimension.

You can use below logic to append the rank

 

=aggr(rank(Dim),Dim)&'-'&Dim

Or share a sample file to work upon.