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
Master
Master

Re: Ranking in Filter Panel

May be you can append rank before like this

 

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

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

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

Highlighted
Master
Master

Re: Ranking in Filter Panel

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

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

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?

Highlighted
Master
Master

Re: Ranking in Filter Panel

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

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

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

Highlighted
Master
Master

Re: Ranking in Filter Panel

Can you try this?

RowNo() & '-' &Your expression

Highlighted
Contributor III
Contributor III

Re: Ranking in Filter Panel

Unfortunately it did not do the trick:

Screenshot - 23_08_2019 , 9_20_21 AM.png

Highlighted
Master
Master

Re: Ranking in Filter Panel

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.