Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the dimension value associated to a max expression

Hello

I would like to get the dimension value associated to the corresponding expression which is maximal.
I mean, let's say i have in a table:

Country - Date - Business - Sales

And i woud like to have in a chart (or in any other way) , per country, the date which matches the maximum value of sales.
I so created a chart with dimensions:

Country

as expression : ????

Thanks a lot for your help ! 🙂

10 Replies
Not applicable
Author

Thanks a lot Jürg, you just saved my life ^^ this works perfectly !!!!

It's perfectly working, i firstly thought about the "firstsortedvalue" but i tried using the other option...

BTW, What does the "%" mean in the loading script ?