0 Replies Latest reply: Jun 29, 2012 12:15 PM by M Paeper RSS

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

    M Paeper



      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