topic Re: Creating Text box with max an min values in QlikView

Creating Text box with max an min values

rido1421 — Wed, 27 Aug 2014 11:00:44 GMT

Hi All

I would like to create 4 text boxes

in each text box I would like to individually Rank them according to the sum of the sales value using a dimension Category

I would need to display the name of the category in one text box overlaying the text box with the sum.

how can I achieve this...

Fields are Category, Value

Ive used the below to get the name of the highest category... but how would i get the 2nd highest... etc

FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category))

ive used this to get the highest number

it seems to be working... but how would i get the 2nd highest etc ...

Max (Aggr(sum(Value),Category))

Appreciate your assistance

ashfaq_haseeb — Wed, 27 Aug 2014 11:03:27 GMT

Try below

FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),2)

FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),3)

Regards

ASHFAQ

giakoum — Wed, 27 Aug 2014 11:03:58 GMT

Why not just using a chart? Same result, more elegant way.

rustyfishbones — Wed, 27 Aug 2014 11:12:17 GMT

Try the following

Object1

FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category)) & CHR(13) &

Max (Aggr(sum(Value),Category))

Object2

FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),2) & CHR(13) &

Max (Aggr(sum(Value),Category),2)

Object3

FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),3) & CHR(13) &

Max (Aggr(sum(Value),Category),3)

Object4

FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),4) & CHR(13) &

Max (Aggr(sum(Value),Category),4)

rido1421 — Wed, 27 Aug 2014 11:13:26 GMT

Thanks Asfaq ..

what about the value?

rido1421 — Wed, 27 Aug 2014 11:14:38 GMT

Thank you very much!