topic Re: Aggr function to find Min Max values not working in QlikView https://community.qlik.com/t5/QlikView/Aggr-function-to-find-Min-Max-values-not-working/m-p/261789#M583509 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>Price is value/qty , right?</P><P></P><P>I just used min(value/qty) resp. max(value/qty) as expressions.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Wed, 19 Oct 2011 23:02:11 GMT swuehl 2011-10-19T23:02:11Z Aggr function to find Min Max values not working https://community.qlik.com/t5/QlikView/Aggr-function-to-find-Min-Max-values-not-working/m-p/261788#M583508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to put a table chart for each product id, similar statistics box.</P><P>Attached sample data that is similar to my scenario, not successful in finding Min and Max values. Somecases, Max value is worked but not Min value as it considers null or zero values.<BR />Appreciate your help.</P><P><BR />Regards,</P><P>Laks</P></BODY></HTML> Wed, 19 Oct 2011 22:21:03 GMT https://community.qlik.com/t5/QlikView/Aggr-function-to-find-Min-Max-values-not-working/m-p/261788#M583508 2011-10-19T22:21:03Z Re: Aggr function to find Min Max values not working https://community.qlik.com/t5/QlikView/Aggr-function-to-find-Min-Max-values-not-working/m-p/261789#M583509 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P><P></P><P>Price is value/qty , right?</P><P></P><P>I just used min(value/qty) resp. max(value/qty) as expressions.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Wed, 19 Oct 2011 23:02:11 GMT https://community.qlik.com/t5/QlikView/Aggr-function-to-find-Min-Max-values-not-working/m-p/261789#M583509 swuehl 2011-10-19T23:02:11Z