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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Min and Max reference lines on chart - Min incorrect when using Aggr expression

Hi,

From the attached QVW I'm getting a 0 plot line for the Minimum value - I expect the light blue dotted line to be plotting at the 1000 0000 level below, but its plotting at 0. QVW is also doing a button toggle between 2 calculations hence the If$(vChange) part but this works fine for the Max value plot. However, when I use the identical expression just replacing the Max function with a Min, it doesnt plot correctly. What do I need to do to I fix the Min level formula? Thanks

I based what I have so far on the example QVW's of John Witherspoon, http://community.qlik.com/message/103391#103391 and http://community.qlik.com/message/23455#23455

The Max formula which works - orange dotted line.

If($(vChange)=1, Max(Aggr(Sum({$<recordGroupName={'Forecast'},YearName={2012}>}Forecast),MonthName)) , Max(Aggr(Sum({$<recordGroupName={'Forecast'},YearName={2012}>}Forecast*PackSize),MonthName)) ) 

The errant formula - light blue dotted line.

If($(vChange)=1, Min(Aggr(Sum({$<recordGroupName={'Forecast'},YearName={2012}>}Forecast),MonthName)) , Min(Aggr(Sum({$<recordGroupName={'Forecast'},YearName={2012}>}Forecast*PackSize),MonthName)) )

QlikView x64 - [X50 DEVTestMaxMinLines.png

0 Replies