topic Set Analysis Question in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/182245#M47975 <HTML><HEAD></HEAD><BODY><P>May I suppose that it is a problem with the date format? To be sure pls check.</P><P>I cannot reproduce it, though if I use 06/08/2009 it works perfectly right with both your expressions. With your 06.08.2009 behaves strange.</P><P>Flavio</P></BODY></HTML> Thu, 10 Sep 2009 22:53:38 GMT eiconsulting 2009-09-10T22:53:38Z Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/182244#M47974 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I use a variable called vToday that contains a date e.g. 06.08.2009</P><P>I tried this:</P><P>sum({$&lt;Datefield = {"$(vToday)"}&gt;} Sales)</P><P>This isn't working.<BR /><BR />If I use sum({$&lt;Datefield = {"&gt;=$(vToday)"}&gt;} Sales), it I'm getting the correct sum.</P><P>can someone please tell me why the first approach doesn't work. Thanks</P><P>Aloah</P></BODY></HTML> Thu, 10 Sep 2009 22:10:45 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/182244#M47974 2009-09-10T22:10:45Z Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/182245#M47975 <HTML><HEAD></HEAD><BODY><P>May I suppose that it is a problem with the date format? To be sure pls check.</P><P>I cannot reproduce it, though if I use 06/08/2009 it works perfectly right with both your expressions. With your 06.08.2009 behaves strange.</P><P>Flavio</P></BODY></HTML> Thu, 10 Sep 2009 22:53:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/182245#M47975 eiconsulting 2009-09-10T22:53:38Z