Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
itcapability
Contributor
Contributor

Min/Max Month on Month Change Not Working To Get Values

I have 2 charts, a monthly average chart and a monthly "delta" chart (see table as example).  The formula used are:

Dimension: [Test Date.autoCalendar.YearMonth]

Measure 1: avg({<ISP={"V*"},[Test Date.autoCalendar.MonthsAgo]={">=1<=6"},[Speed]={">0<=80"}>} [Speed])

Measure 2: avg({<ISP={"V*"},[Test Date.autoCalendar.MonthsAgo]={">=1<=6"},[Speed]={">0<=80"}>} [Speed])
  -above(avg({<ISP={"V*"},[Test Date.autoCalendar.MonthsAgo]={">=1<=6"},[Speed]={">0<=80"}>} [Speed]))

 
Test Date.YearMonthMonthly AverageMonthly Delta
2019-Jul28.72-
2019-Aug27.20-1.52
2019-Sep30.152.95
2019-Oct31.161.01
2019-Nov31.230.07
2019-Dec31.04-0.19

 

These 2 formula work fine in a chart or table. I am now trying to find the minimum and maximum values (red and blue in the table above).  I have wrapped Measure 2 with max(aggr()) in various ways and either get a "cannot have nested aggregation" error, no value or the wrong value (2.5, 13, 63, 71).

I'm not sure what I need to do know. Any help ??

Regards,

Adrian

Labels (1)
0 Replies