topic Re: Dynamic Min/Max in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Min-Max/m-p/756637#M269374 <HTML><HEAD></HEAD><BODY><P>Can you attach your sample file. Also have you tried unchecking 'Forced 0' option. </P></BODY></HTML> Thu, 08 Jan 2015 20:42:34 GMT 2015-01-08T20:42:34Z Dynamic Min/Max https://community.qlik.com/t5/QlikView/Dynamic-Min-Max/m-p/756636#M269373 <HTML><HEAD></HEAD><BODY><P>Hello World,</P><P></P><P>I have a chart with buttons that switch months. Each month shows results 120 prior to the month shown. Since some months have extremes it can make the chart hard to read. I want to have the chart scale to which ever period the user is looking at. So far I have tried this and other variations: </P><P></P><P>=MIN(AGGR(</P><P>(Rangesum(Above(sum({ &lt;&nbsp; DRR_CO&nbsp; = {'&gt;=$(=num(vSDate)) &lt;=$(=num(vEndDdate))'}, BookDateDRR=&nbsp; &gt;} DRR_PAX_COUNT_HOTEL ) ,0, vMovingAverage)))/</P><P>Rangesum(Above(sum({ &lt; DRR_CO&nbsp; = {'&gt;=$(=num(vSDate)) &lt;=$(=num(vEndDdate))'}, BookDateDRR=&nbsp; &gt;} DRR_PAX_COUNT_SS)&nbsp; ,0, vMovingAverage))</P><P></P><P></P><P>,BookDateDRR ))</P><P></P><P>When I run this it returns 0.</P><P></P><P>Any help would be super awesome!</P><P></P><P>-Jacob</P></BODY></HTML> Thu, 08 Jan 2015 19:58:06 GMT https://community.qlik.com/t5/QlikView/Dynamic-Min-Max/m-p/756636#M269373 2015-01-08T19:58:06Z Re: Dynamic Min/Max https://community.qlik.com/t5/QlikView/Dynamic-Min-Max/m-p/756637#M269374 <HTML><HEAD></HEAD><BODY><P>Can you attach your sample file. Also have you tried unchecking 'Forced 0' option. </P></BODY></HTML> Thu, 08 Jan 2015 20:42:34 GMT https://community.qlik.com/t5/QlikView/Dynamic-Min-Max/m-p/756637#M269374 2015-01-08T20:42:34Z