Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

max sale based on year in a text box

i am trying to display maximum sale,when aggregated by year in a text box. when i am clicking on year listbox,maximum sale is changiing

i use following function to get maximum sale aggregated with year

=max(Aggr(sum({<year,qtr>}sales),year))


Capture1.JPGCapture.JPG

1 Solution

Accepted Solutions
Highlighted

Try this:

=Max({<year, qtr>}Aggr(Sum({<year,qtr>}sales), year))

View solution in original post

2 Replies
Highlighted

Try this:

=Max({<year, qtr>}Aggr(Sum({<year,qtr>}sales), year))

View solution in original post

Highlighted
Not applicable

thanks sunny