Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Specialist II
Specialist II

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

 

 

Highlighted
Contributor III
Contributor III

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

Highlighted
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

Highlighted
Contributor III
Contributor III

Thank you!

It works perfect!