Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Selecting a single value of a field, according to specific condition

Hello everybody,

I have a fomula that displays the maximum aggregated value of a certain field. This expression is shown here below:

'*'&num(MAX(TOTAL AGGR(sum({<$(v_CY), $(v_CY_BP), CD_SCENARIO={'ACT'}, [DMD Code] =- {'ND'}>}[AM_NET_SALES]), [Dealer Name]))/1000,'#,###.0')&' k$'

I would like to know which is the formula to display the Deler Name that corresponds to the maximum value, obtained with the formula above.

Thank you very much.

0 Replies