Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
saradhi_it
Contributor II

Evaluate top 1 field and value

Hi Friends,

Please help me out in getting top one sales in desired format.

Thanks,
PRS

sd.jpg

1 Reply
Highlighted
Partner
Partner

Re: Evaluate top 1 field and value

hi you can use

firstsortedvalue(Product,-Sales) for the name

and firstsortedvalue(Sales,-Sales) for the value