https://community.qlik.com/t5/App-Development/Date-variable-in-a-set-analysis/m-p/1984540#M81234 <P>Hello,</P> <P>I would like to use this type of measurement :</P> <P>Sum({$&lt;DATE_START={"&lt;=$(=$(vDATEW))"}&gt;}Weight)</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="100%">DATE_START</TD> </TR> <TR> <TD width="100%">05/07/2022</TD> </TR> <TR> <TD width="100%">24/08/2022</TD> </TR> <TR> <TD width="100%">22/09/2022</TD> </TR> </TBODY> </TABLE> <P>(There is almost one date line per day for 1 year)</P> <P>&nbsp;</P> <P>If I enter 20/09/2022 in vDATEW, it doesn't work, but I think it comes from the date processing :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Obsyky_0-1663915704882.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/89737iFF9B795BC67B0940/image-size/medium?v=v2&amp;px=400" role="button" title="Obsyky_0-1663915704882.png" alt="Obsyky_0-1663915704882.png" /></span></P> <P>How can I solve this problem? Thank you</P> <P>&nbsp;</P> Fri, 23 Sep 2022 06:59:48 GMT Obsyky 2022-09-23T06:59:48Z https://community.qlik.com/t5/App-Development/Date-variable-in-a-set-analysis/m-p/1984540#M81234 <P>Hello,</P> <P>I would like to use this type of measurement :</P> <P>Sum({$&lt;DATE_START={"&lt;=$(=$(vDATEW))"}&gt;}Weight)</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="100%">DATE_START</TD> </TR> <TR> <TD width="100%">05/07/2022</TD> </TR> <TR> <TD width="100%">24/08/2022</TD> </TR> <TR> <TD width="100%">22/09/2022</TD> </TR> </TBODY> </TABLE> <P>(There is almost one date line per day for 1 year)</P> <P>&nbsp;</P> <P>If I enter 20/09/2022 in vDATEW, it doesn't work, but I think it comes from the date processing :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Obsyky_0-1663915704882.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/89737iFF9B795BC67B0940/image-size/medium?v=v2&amp;px=400" role="button" title="Obsyky_0-1663915704882.png" alt="Obsyky_0-1663915704882.png" /></span></P> <P>How can I solve this problem? Thank you</P> <P>&nbsp;</P> Fri, 23 Sep 2022 06:59:48 GMT https://community.qlik.com/t5/App-Development/Date-variable-in-a-set-analysis/m-p/1984540#M81234 Obsyky 2022-09-23T06:59:48Z https://community.qlik.com/t5/App-Development/Date-variable-in-a-set-analysis/m-p/1984545#M81236 <P>hi</P> <P>$() - indicates evaluate the expression.</P> <P>If you mention $(vDATEW) - means, it will evaluate the values like 20 divide by 9 (result) divide by 2022.</P> <P>In that case, you can simply use&nbsp;</P> <P><SPAN>vDATEW</SPAN></P> <P><SPAN>or</SPAN></P> <P><SPAN>change the value of the vDATEW as "MakeDate(2022,09,22)" then,&nbsp;=$(vDATEW) it gives 20/9/2022 date value</SPAN></P> Fri, 23 Sep 2022 07:07:40 GMT https://community.qlik.com/t5/App-Development/Date-variable-in-a-set-analysis/m-p/1984545#M81236 MayilVahanan 2022-09-23T07:07:40Z