topic Simple question about reusing expression on chart in QlikView https://community.qlik.com/t5/QlikView/Simple-question-about-reusing-expression-on-chart/m-p/766508#M272353 <HTML><HEAD></HEAD><BODY><P>Dear All, I have below 2 expressions on same dimension, and they both work,</P><P>what i want is to replace '2014/2/26' with return of Exp2 </P><P>but i failed, no matter i try using the expression name, </P><P>the whole Exp 2, the $(= ) expansion,&nbsp; and i am quite sure that&nbsp; Exp2 return '2014/2/26' on that dimension.</P><P>anyone can help and explain? Many Thanks! </P><P></P><P>Exp1: only( if([Price start date]&lt;='2014/2/26' and [Price end date]&gt;='2014/2/26' and [Price price center] = [Price center],&nbsp; [Original price] ))</P><P></P><P></P><P>Exp2: max({$&lt;[Onfloor date]={'&lt;=$(=MAX([Manual calendar date]))'}&gt;}[Onfloor date])</P></BODY></HTML> Tue, 04 Nov 2014 17:51:27 GMT 2014-11-04T17:51:27Z Simple question about reusing expression on chart https://community.qlik.com/t5/QlikView/Simple-question-about-reusing-expression-on-chart/m-p/766508#M272353 <HTML><HEAD></HEAD><BODY><P>Dear All, I have below 2 expressions on same dimension, and they both work,</P><P>what i want is to replace '2014/2/26' with return of Exp2 </P><P>but i failed, no matter i try using the expression name, </P><P>the whole Exp 2, the $(= ) expansion,&nbsp; and i am quite sure that&nbsp; Exp2 return '2014/2/26' on that dimension.</P><P>anyone can help and explain? Many Thanks! </P><P></P><P>Exp1: only( if([Price start date]&lt;='2014/2/26' and [Price end date]&gt;='2014/2/26' and [Price price center] = [Price center],&nbsp; [Original price] ))</P><P></P><P></P><P>Exp2: max({$&lt;[Onfloor date]={'&lt;=$(=MAX([Manual calendar date]))'}&gt;}[Onfloor date])</P></BODY></HTML> Tue, 04 Nov 2014 17:51:27 GMT https://community.qlik.com/t5/QlikView/Simple-question-about-reusing-expression-on-chart/m-p/766508#M272353 2014-11-04T17:51:27Z