Solved: Get Dimension with Highest Value - Qlik Community

Anonymous · ‎2018-06-13

Hi,

I want to show the date with has the highest total sum of amount in a KPI , does anyone know how.

Amount Date

Thanks

sunny_talwar · ‎2018-06-13

May be this

FirstSortedValue(Date, -Aggr(Sum(Amount), Date))

ogautier62 · ‎2018-06-13

Hi,

create a sheet with Date in dimension,

and in expression :

if(sum(kpi) = max(total aggr(nodistinct sum(kpi),date)),date)

date with the max sum kpi will appear

regards

sunny_talwar · ‎2018-06-13

May be this

FirstSortedValue(Date, -Aggr(Sum(Amount), Date))

Anonymous · ‎2018-06-14

Thanks, have previously seen your answer elsewhere and tried it.

Realized that my output was not in date format.

Total carelessness on my side.

ogautier62 · ‎2018-06-14

Yes!!!!

I made a copy paste of your text

Replace And with, (comma)

And Maxstring in place of max for a string

Naushad07 · ‎2019-12-23

I am using a similar formula. It works fine without '-'(minus) sign, but when I'm using a minus sign, I am not getting any value.

I used the same formula for Table and it works, but I'm not getting any values for a KPI.