Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
josemaria_cabre
Contributor III
Contributor III

Help with Max value over dimension

Hi,
I'm having trouble finding month with max value from this set of data:

459cabcf0848431c951a399be781bf2c.png

I'm looking for an expression that returns 8.28 M, but with this expression:

Max( total <[IssueDate.autoCalendar.Month]> aggr( $(v.TotalCost), [IssueDate.autoCalendar.Month])) 

I'm getting 12.88 M, (which is the sum of 8.28 M + 4.6 M ...)

How should I modify this expression to return max value from all months, but without aggregating ?

Thanks in advance for your help,
Jose

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

What is the second dimension in your chart? Try this

Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], Dimension2)) 

View solution in original post

2 Replies
sunny_talwar

What is the second dimension in your chart? Try this

Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], Dimension2)) 
josemaria_cabre
Contributor III
Contributor III
Author

Second dimension is [IssueDate.autoCalendar.Year], and now it works with:

Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], [IssueDate.autoCalendar.Year]))

Thanks a lot for your help Sunny!