Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Creator III
Creator III
‎2022-06-15 02:28 AM

Max(Aggr(Max(Temperature), Location, MAC, [Datetime.autoCalendar.Month], Comment))

Hi experts

I have the above expression.

This expression should calculate the maximum temperature value of the given dimenion combination. But it still shows the maximum of the whole result set. Where is the error?

Thanks

Labels (2)
Labels
123 Views
0 Likes
2 Replies
lyr_com
Contributor II
Contributor II
‎2022-06-16 03:17 AM

Hi,

I understand that you want to obtain the maximum temperature of the group formed by: Location, MAC, month and comment?

Try: Aggr(Max(Temperature), Location, MAC, [Datetime.autoCalendar.Month], Comment)

101 Views
0 Likes
TomBond77
Creator III
Creator III
‎2022-06-16 03:21 AM
Author

the above formula mentioned myself is correct. I misinterpreted the result. Thanks.

99 Views
0 Likes