topic Re: How to create a condition using a variable? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-condition-using-a-variable/m-p/363664#M135269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Put the value 52 in variable ,let the name of variable be "vVal"</P><P>thn try the below expression</P><P></P><P>=sum({&lt;Week ={"&gt;$(vPeriod) &lt;=$(vVal)"}&gt;} Sales)</P><P></P><P>hope this will work.</P></BODY></HTML> Thu, 21 Jun 2012 08:52:52 GMT 2012-06-21T08:52:52Z How to create a condition using a variable? https://community.qlik.com/t5/QlikView/How-to-create-a-condition-using-a-variable/m-p/363662#M135267 <HTML><HEAD></HEAD><BODY><DIV>Hi,</DIV><DIV> </DIV><DIV>I have a field named week with 104 weeks.</DIV><DIV>I want to filter a sum for the weeks going between a variable named "vPeriod" and week 52. I have been trying things like the following unsuccessfully.</DIV><DIV> </DIV><DIV><SPAN style="color: #008000; font-size: 8pt;"><DIV>Sum ( { &lt;Week = {"&lt;=52"}, Week={"&gt;$(vPeriod)"}&gt;}&nbsp; Sales)</DIV></SPAN></DIV><DIV>Any help?Thanks</DIV></BODY></HTML> Tue, 22 May 2012 14:23:56 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-condition-using-a-variable/m-p/363662#M135267 Anonymous 2012-05-22T14:23:56Z Re: How to create a condition using a variable? https://community.qlik.com/t5/QlikView/How-to-create-a-condition-using-a-variable/m-p/363663#M135268 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>You were close. Did a formula similar to this a week ago. It should be:</P><P></P><P>Sum({ &lt;Week = {'&lt;=52&gt;$(vPeriod)'}&gt;}&nbsp; Sales)</P><P></P><P>Best Regars</P><P>Johan Lindell</P></BODY></HTML> Thu, 21 Jun 2012 08:22:25 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-condition-using-a-variable/m-p/363663#M135268 johanlindell 2012-06-21T08:22:25Z Re: How to create a condition using a variable? https://community.qlik.com/t5/QlikView/How-to-create-a-condition-using-a-variable/m-p/363664#M135269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Put the value 52 in variable ,let the name of variable be "vVal"</P><P>thn try the below expression</P><P></P><P>=sum({&lt;Week ={"&gt;$(vPeriod) &lt;=$(vVal)"}&gt;} Sales)</P><P></P><P>hope this will work.</P></BODY></HTML> Thu, 21 Jun 2012 08:52:52 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-condition-using-a-variable/m-p/363664#M135269 2012-06-21T08:52:52Z