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: 
paddy64
Contributor
Contributor

Rank in the title

Good evening, anybody knows how i can put, in the title expression of a chart, the rank of a special dimension?

Eg :Have 9 countries with 9 amount of sales. England is the 3rd on ranking. Want to put on the title something like : "Englands is the 3rd country regarding sum of sales".

 

Thank you very much lads for help

 

 

4 Replies
Anil_Babu_Samineni

Perhaps this as title?

FirstSortedValue(DISTINCT Country, -Aggr(Sum({<Month = {">=$(=AddMonths(Max(Month),-9))<=$(=Max(Month))"}>} sales), Dim1, Dim2..), 3)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Channa
Specialist III
Specialist III

=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)=3,COUNTRY_NAME_EN)

it shows country name dynamic rank=3

If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)=3,COUNTRY_NAME_EN) & '3rd country'

 

try like this

Channa
paddy64
Contributor
Contributor
Author

Hi Lovisfail, and thank you for your trial.

 

I tried your expression as follows, but no rank is coming out, though the expressions seems OK . Maybe the end of expression?  

FirstSortedValue(DISTINCT Country, -Aggr(Sum({<Month = {">=$(=AddMonths(Max(Month),-9))<=$(=Max(Month))"}>} sales), Country)3)

 

Thank you in advance

 

paddy64
Contributor
Contributor
Author

Hello Channa, thank you for your reply. Tried the expression but doesn't come out...If you have any idea i could try.

Patrick