topic Re: Finding Dimension value for a aggregated value in QlikView

Finding Dimension value for a aggregated value

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

max(aggr(sum(Sales),Country))

Above expression gives me max of sale (aggregated range) . But i want to display the country in a text box , which is having max sales (using above expression) , . Please help me with the expression .

Also the expression for second highest and third highest country in separate text box . Need help on the expression .

I have attached data as well .

Thanks & Regards

Shekar

Re: Finding Dimension value for a aggregated value

sunny_talwar — Sat, 25 Mar 2017 20:50:43 GMT

Try this

FirstSortedValue(Country, -Aggr(Sum(Sales), Country))

Re: Finding Dimension value for a aggregated value

sunny_talwar — Sat, 25 Mar 2017 20:51:59 GMT

For 2nd and 3rd highest, you can use this

2nd highest

FirstSortedValue(Country, -Aggr(Sum(Sales), Country), 2)

3rd highest

FirstSortedValue(Country, -Aggr(Sum(Sales), Country), 3)