topic Using a variable to store an expression? in QlikView https://community.qlik.com/t5/QlikView/Using-a-variable-to-store-an-expression/m-p/576158#M214380 <HTML><HEAD></HEAD><BODY><P>I have a variable 'vSummaryTrendAnalysisPCWeek' defined as the following:</P><P></P><P>= Sum({&lt;[Week] ={"&gt;$(=num(Week(Max([Trade Date]))-13))&lt;=$(=num(Week(Max([Trade Date]))))"}&gt;} [$ PC])</P><P></P><P>However, if I try and plug that variable into a chart as an expression, I just get one number returned.</P><P></P><P>If I put that line in as an expression, it works fine.&nbsp; </P><P></P><P>I get the impression that there's some aspect of quotes and / or $ expansion of the variable that I need to use, but I can't for the life of me work out what I'm supposed to do, anyone got any ideas? Cheers.</P></BODY></HTML> Tue, 29 Apr 2014 13:53:25 GMT richnorris 2014-04-29T13:53:25Z Using a variable to store an expression? https://community.qlik.com/t5/QlikView/Using-a-variable-to-store-an-expression/m-p/576158#M214380 <HTML><HEAD></HEAD><BODY><P>I have a variable 'vSummaryTrendAnalysisPCWeek' defined as the following:</P><P></P><P>= Sum({&lt;[Week] ={"&gt;$(=num(Week(Max([Trade Date]))-13))&lt;=$(=num(Week(Max([Trade Date]))))"}&gt;} [$ PC])</P><P></P><P>However, if I try and plug that variable into a chart as an expression, I just get one number returned.</P><P></P><P>If I put that line in as an expression, it works fine.&nbsp; </P><P></P><P>I get the impression that there's some aspect of quotes and / or $ expansion of the variable that I need to use, but I can't for the life of me work out what I'm supposed to do, anyone got any ideas? Cheers.</P></BODY></HTML> Tue, 29 Apr 2014 13:53:25 GMT https://community.qlik.com/t5/QlikView/Using-a-variable-to-store-an-expression/m-p/576158#M214380 richnorris 2014-04-29T13:53:25Z Re: Using a variable to store an expression? https://community.qlik.com/t5/QlikView/Using-a-variable-to-store-an-expression/m-p/576159#M214381 <HTML><HEAD></HEAD><BODY><P>Of course, I just had to remove the leading = sign. I am idiot.</P></BODY></HTML> Tue, 29 Apr 2014 13:56:13 GMT https://community.qlik.com/t5/QlikView/Using-a-variable-to-store-an-expression/m-p/576159#M214381 richnorris 2014-04-29T13:56:13Z