Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. 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!