Aggr and Rank function to limit the output to a fixed rane

QlikNAM — Wed, 08 May 2024 08:36:17 GMT

Hi All

Im using the AGGR and Rank function to create a rank for each output value for that dimension

Aggr(Rank(1-count({<[somefield]={'Osomevaluet'}>}A_number)/count(A_number)),$(vDimValue))

the dimensions can be anything from 3 to 10+ values so currently my rank produces the values (1,2,3.....10+) or however many dimension values exist.

I want the rank to automatically limit the values of rank between 1 to 5 one being lowest output value aggregated over the dimension.. i don't want to fix the value if output between a and b value 1., else 2...... is there a dynamic way to calculate a range of rank -1-5 based on the values for that dimension

any help appreciated

Re: Aggr and Rank function to limit the output to a fixed rane

F_B — Mon, 17 Jun 2024 11:43:28 GMT

Hi @QlikNAM ,

if I undersood your request right, you could try to adjust your expression like this:

Aggr(If(Rank(1 - count({<[somefield]={'Osomevaluet'}>} A_number) / count(A_number)) <= 5,Rank(1 -count({<[somefield]={'Osomevaluet'}>} A_number) / count(A_number)),5),$(vDimValue))

Hope this helps

topic Aggr and Rank function to limit the output to a fixed rane in App Development

Aggr and Rank function to limit the output to a fixed rane

Re: Aggr and Rank function to limit the output to a fixed rane