topic Re: Rank Function Problem in QlikView

Rank Function Problem

dominikkeller — Sat, 16 Nov 2024 01:16:10 GMT

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)

Image 2 The goal

Thanks for any help!

Re: Rank Function Problem

qliksus — Wed, 19 Feb 2020 08:35:18 GMT

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

Re: Rank Function Problem

dominikkeller — Wed, 19 Feb 2020 09:58:26 GMT

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

Re: Rank Function Problem

qliksus — Thu, 20 Feb 2020 07:33:17 GMT

Try this in the text box

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

Re: Rank Function Problem

dominikkeller — Thu, 20 Feb 2020 10:46:26 GMT

Thank you!

It works perfect!