topic Re: Optimize expression in QlikView https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635760#M233174 <HTML><HEAD></HEAD><BODY><P>I think it is not possible!</P></BODY></HTML> Fri, 16 May 2014 10:05:20 GMT alexandros17 2014-05-16T10:05:20Z Optimize expression https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635759#M233173 <HTML><HEAD></HEAD><BODY><P>I have expression: if($(SumQty)&gt;0,$(SumQty),0), but SumQty is very hard expression: </P><P>Money(Sum(Aggr($(SumQtyFormula) * $(CostQty)/1000,</P><P>&nbsp; ItemId, DepartmentId, VendId)),'# ##0,00').</P><P>When I write if($(SumQty)&gt;0,$(SumQty),0) - QV calc $(SumQty) twice? How I can change expression that calc once?</P></BODY></HTML> Fri, 16 May 2014 10:03:21 GMT https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635759#M233173 2014-05-16T10:03:21Z Re: Optimize expression https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635760#M233174 <HTML><HEAD></HEAD><BODY><P>I think it is not possible!</P></BODY></HTML> Fri, 16 May 2014 10:05:20 GMT https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635760#M233174 alexandros17 2014-05-16T10:05:20Z Re: Optimize expression https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635761#M233175 <HTML><HEAD></HEAD><BODY><P>try:</P><P></P><P>rangemax($(SumQty),0)</P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Fri, 16 May 2014 10:27:16 GMT https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635761#M233175 2014-05-16T10:27:16Z Re: Optimize expression https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635762#M233176 <HTML><HEAD></HEAD><BODY><P>Thank you so much!</P></BODY></HTML> Fri, 16 May 2014 10:34:28 GMT https://community.qlik.com/t5/QlikView/Optimize-expression/m-p/635762#M233176 2014-05-16T10:34:28Z