topic Re: set analysis and variable in QlikView https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285331#M106094 <HTML><HEAD></HEAD><BODY><P>thank you!</P></BODY></HTML> Fri, 23 Sep 2011 12:50:33 GMT 2011-09-23T12:50:33Z set analysis and variable https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285326#M106089 <HTML><HEAD></HEAD><BODY><P>once i think i have this under the belt, i just don't.</P><P></P><P>i want to use set analysis to based on variable.</P><P></P><P>the variable is today's date called vdate.</P><P></P><P>i want sum of sales where salesdate = vdate.</P><P>help please?</P><P></P><P>Lambert Badenhorst.</P></BODY></HTML> Fri, 23 Sep 2011 12:07:49 GMT https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285326#M106089 2011-09-23T12:07:49Z set analysis and variable https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285327#M106090 <HTML><HEAD></HEAD><BODY><P>use below</P><P></P><P>sum({&lt;salesdate ={"$(vdate)"}&gt;}sales)</P></BODY></HTML> Fri, 23 Sep 2011 12:16:14 GMT https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285327#M106090 SunilChauhan 2011-09-23T12:16:14Z Re: set analysis and variable https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285328#M106091 <HTML><HEAD></HEAD><BODY><P>Hi Lambert,</P><P></P><P>try sum({&lt;salesdate={$(#vdate)}&gt;} sales) or sum({&lt;salesdate={$(#=date(today()))}&gt;} sales)</P><P></P><P>C u,</P><P>Stefano</P></BODY></HTML> Fri, 23 Sep 2011 12:17:18 GMT https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285328#M106091 2011-09-23T12:17:18Z set analysis and variable https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285329#M106092 <HTML><HEAD></HEAD><BODY><P> thank you!</P></BODY></HTML> Fri, 23 Sep 2011 12:49:51 GMT https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285329#M106092 2011-09-23T12:49:51Z Re: set analysis and variable https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285330#M106093 <HTML><HEAD></HEAD><BODY><P>thank you!</P></BODY></HTML> Fri, 23 Sep 2011 12:50:14 GMT https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285330#M106093 2011-09-23T12:50:14Z Re: set analysis and variable https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285331#M106094 <HTML><HEAD></HEAD><BODY><P>thank you!</P></BODY></HTML> Fri, 23 Sep 2011 12:50:33 GMT https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285331#M106094 2011-09-23T12:50:33Z Re: set analysis and variable https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285332#M106095 <HTML><HEAD></HEAD><BODY><P>This worked perfectly for an expression I was working on. Thanks!</P></BODY></HTML> Wed, 20 Jun 2012 12:24:28 GMT https://community.qlik.com/t5/QlikView/set-analysis-and-variable/m-p/285332#M106095 jcampbell 2012-06-20T12:24:28Z