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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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 ?