Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in set analysis - Min and Max of Sales

Hi,

In a sales application how do i find the maximum of the sales and the minmum of the sales in a year.

Please find the attached...

Regards

Chriss

1 Reply
Not applicable
Author

Are you looking for Min/Max Amount per year?  Try this:

=Min({$<Year={'2012'}>} Amount)

=Max({$<Year={'2012'}>} Amount)