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: 
dominikkeller
Contributor III
Contributor III

Rank Function Problem

Hello everybody,

 

I have a problem with the Rank function.

In my report (which runs individually over 30 outles) only gives the rank of the respective company.

The rank function should create a rank among the outlets for each month and each value description of the value.

My first thought was to calculate a new field in the script. Problem i don't know how to build this formula.

Idea 2 with a formula in a text field, but I also can't get this formula together.

Picture 1 my table

(i created the field rank in excel for demo)

picture 1.png

Image 2 The goal

Picture 2.jpeg

 

Thanks for any help!

Labels (3)
1 Solution

Accepted Solutions
qliksus
Specialist II
Specialist II

Try this in the text box

 

aggr( rank(sum({$<Filiale.Filiale=>}BWA.BWA.BWA_Wert),0) , Filiale.Filiale)

View solution in original post

4 Replies
qliksus
Specialist II
Specialist II

Can  you attach some sample?  what are you getting when you use just the rank function ?

 

 

dominikkeller
Contributor III
Contributor III
Author

Yes,

the rank function in the table you see is correct. But i need to select a Outlet (Filiale.Filiale) an then i need the rank from the Table in the Textbox.

Thanks for your help

qliksus
Specialist II
Specialist II

Try this in the text box

 

aggr( rank(sum({$<Filiale.Filiale=>}BWA.BWA.BWA_Wert),0) , Filiale.Filiale)

dominikkeller
Contributor III
Contributor III
Author

Thank you!

It works perfect!