topic min and max in chart in QlikView https://community.qlik.com/t5/QlikView/min-and-max-in-chart/m-p/194784#M55555 <HTML><HEAD></HEAD><BODY><P>It works! Thanks!</P></BODY></HTML> Tue, 22 Dec 2009 18:15:49 GMT 2009-12-22T18:15:49Z min and max in chart https://community.qlik.com/t5/QlikView/min-and-max-in-chart/m-p/194782#M55553 <HTML><HEAD></HEAD><BODY><P>Why does the following expression not work in a chart?</P><P></P><P>Sum(if(Year=Max(Year),Profit,0))-Sum(if(Year=Min(Year),Profit,0))</P><P>If have selected more than one Year</P><BR /><BR /></BODY></HTML> Tue, 22 Dec 2009 17:35:46 GMT https://community.qlik.com/t5/QlikView/min-and-max-in-chart/m-p/194782#M55553 2009-12-22T17:35:46Z min and max in chart https://community.qlik.com/t5/QlikView/min-and-max-in-chart/m-p/194783#M55554 <HTML><HEAD></HEAD><BODY><P>Try Max(Total Year) and Min(Total Year) in place of Max(Year) and Min(Year).</P><P>Does this work? Why?</P></BODY></HTML> Tue, 22 Dec 2009 17:49:28 GMT https://community.qlik.com/t5/QlikView/min-and-max-in-chart/m-p/194783#M55554 2009-12-22T17:49:28Z min and max in chart https://community.qlik.com/t5/QlikView/min-and-max-in-chart/m-p/194784#M55555 <HTML><HEAD></HEAD><BODY><P>It works! Thanks!</P></BODY></HTML> Tue, 22 Dec 2009 18:15:49 GMT https://community.qlik.com/t5/QlikView/min-and-max-in-chart/m-p/194784#M55555 2009-12-22T18:15:49Z