https://community.qlik.com/t5/Water-Cooler/How-to-parametrize-the-date-expression/m-p/1522859#M7704 <P>What do you meant with parametrize the date expression?</P><P>I don't know your data and requirements and your approach might be sensible but for me it looked like an overusing of variables because they have the aim to simplify things and here I'm not sure they does.</P><P>- Marcus</P> Thu, 20 Dec 2018 08:17:43 GMT marcus_sommer 2018-12-20T08:17:43Z https://community.qlik.com/t5/Water-Cooler/How-to-parametrize-the-date-expression/m-p/1522850#M7702 <P>Hello there,</P><P>I would like to put parameters in my date variables , below are my expressions</P><DIV>vSetMTD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =Year={'$(vMaxYear)'},Month={'$(vMaxMonth)'},Day={'&lt;=$(vMaxDay)'},Date=,MonthYear=<BR />vSetPreviousMonth&nbsp;&nbsp; =Year={'$(vPriorMonthYear)'},Month={'$(vPriorMonth)'},Day={'&lt;=$(vMaxDay)'},Date=,MonthYear=</DIV><DIV>&nbsp;</DIV><DIV>eCntFlgCurr&nbsp; =&nbsp; count({&lt;$(vSetMTD)&gt;}Flags)</DIV><DIV>&nbsp;</DIV><DIV>eCntMajCurr&nbsp; =count({$&lt;Flags={'MajFlagTrc'},$(vSetMTD)&gt;}Flags)+ count({$&lt;Flags={'MajFlagPipe'},$(vSetMTD)&gt;}Flags)</DIV><DIV><BR />eCntMajCurr% =num(($(eCntMajCurr))/$(eCntFlgCurr),'#0.%')</DIV><DIV>&nbsp;</DIV><DIV>Thanks</DIV> Thu, 20 Dec 2018 07:25:02 GMT https://community.qlik.com/t5/Water-Cooler/How-to-parametrize-the-date-expression/m-p/1522850#M7702 zwyne 2018-12-20T07:25:02Z https://community.qlik.com/t5/Water-Cooler/How-to-parametrize-the-date-expression/m-p/1522859#M7704 <P>What do you meant with parametrize the date expression?</P><P>I don't know your data and requirements and your approach might be sensible but for me it looked like an overusing of variables because they have the aim to simplify things and here I'm not sure they does.</P><P>- Marcus</P> Thu, 20 Dec 2018 08:17:43 GMT https://community.qlik.com/t5/Water-Cooler/How-to-parametrize-the-date-expression/m-p/1522859#M7704 marcus_sommer 2018-12-20T08:17:43Z