Discussion board where members can get started with Qlik Sense.
Hello people, would appreciate your help
Suppose I have a data structure which contains just 3 fields: Client, Region and Sales
I want to display, using a single formula, the Region with the highest sales
I now how to calculate the sales of the Region with the highest sales:
but how can I also display the Region that the above value corresponds to?
of course I can do this using a simple table with region and sales with a limitation set to 1 in the dimension field, but I need to insert this information in the title of a gauge
your help is much appreciated
Go to Solution.
Only( aggr( if( sum(Sales) = max( total aggr(sum(Sales),Region)), Region, null() ), Region ) )
yes that worked, fantastic!
I am now trying to understand the formula.
thank you very much
your formula also works