topic Re: Using Variable in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707071#M254800 <HTML><HEAD></HEAD><BODY><P>Hi Geoff,</P><P></P><P>Can you please provide me the sample app or data, so that i can work on.</P><P></P><P>Regards,</P><P>@vi</P></BODY></HTML> Thu, 03 Jul 2014 14:57:32 GMT avinashelite 2014-07-03T14:57:32Z Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707066#M254795 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm trying to get this to work:</P><P></P><P>=Sum({&lt;Year={vThisYear}&gt;}[ActivityPlan])</P><P></P><P>Have tried juggling apostrophies, speech marks etc to no avail, can anyone help please?</P><P></P><P>Cheers</P><P>Geoff</P></BODY></HTML> Thu, 03 Jul 2014 14:35:07 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707066#M254795 2014-07-03T14:35:07Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707067#M254796 <HTML><HEAD></HEAD><BODY><P>Hi Geoff,</P><P></P><P>Please Try with this format</P><P>=Sum({&lt;Year={$(vThisYear)}&gt;}[ActivityPlan])</P><P></P><P>Regards,</P><P>@vi</P></BODY></HTML> Thu, 03 Jul 2014 14:39:05 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707067#M254796 avinashelite 2014-07-03T14:39:05Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707068#M254797 <HTML><HEAD></HEAD><BODY><P>Hi Avi</P><P></P><P>Thanks but no joy. Have attached a screen show the nuts and bolts are in place.</P><P></P><P>Cheers</P><P>Geoff<IMG alt="QVVariable.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61696_QVVariable.JPG.jpg" style="width: 620px; height: 496px;" /></P></BODY></HTML> Thu, 03 Jul 2014 14:48:46 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707068#M254797 2014-07-03T14:48:46Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707069#M254798 <HTML><HEAD></HEAD><BODY><P>As <A href="https://community.qlik.com/qlik-users/130924">Avinash R</A> says, you need to use <EM>Dollar Sign Expansion</EM> to push the actual value of the variable into your expression - it's a handy thing to remember.</P></BODY></HTML> Thu, 03 Jul 2014 14:51:39 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707069#M254798 ThornOfCrowns 2014-07-03T14:51:39Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707070#M254799 <HTML><HEAD></HEAD><BODY><P>You have <STRONG>var</STRONG>ThisYear in the purple box and <STRONG>v</STRONG>ThisYear in the blue one. Make sure you're using the right one in your expression and to put the dollar sign in place.</P></BODY></HTML> Thu, 03 Jul 2014 14:52:45 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707070#M254799 ThornOfCrowns 2014-07-03T14:52:45Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707071#M254800 <HTML><HEAD></HEAD><BODY><P>Hi Geoff,</P><P></P><P>Can you please provide me the sample app or data, so that i can work on.</P><P></P><P>Regards,</P><P>@vi</P></BODY></HTML> Thu, 03 Jul 2014 14:57:32 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707071#M254800 avinashelite 2014-07-03T14:57:32Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707072#M254801 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have tried this with all three expressions in a chart and get an empty table back. Hard coding '2014-15' works in the expression. I'd like to get this set so I don't have to go through all the expressions in n charts this time next year.</P><P></P><P>Cheers</P><P>Geoff</P></BODY></HTML> Thu, 03 Jul 2014 14:59:25 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707072#M254801 2014-07-03T14:59:25Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707073#M254802 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Sorry typo in purple box. Expressions in app are vThisYear and are grey and itallic.</P></BODY></HTML> Thu, 03 Jul 2014 15:02:36 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707073#M254802 2014-07-03T15:02:36Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707074#M254803 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try some thing like below</P><P></P><P><STRONG>=Sum({&lt;Year={'$(=vThisYear)'}&gt;}[ActivityPlan])</STRONG></P></BODY></HTML> Thu, 03 Jul 2014 15:02:42 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707074#M254803 sasikanth 2014-07-03T15:02:42Z Re: Using Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707075#M254804 <HTML><HEAD></HEAD><BODY><P>Hi Sasikanth</P><P></P><P>Spot on&nbsp; - adding the = before the variable has done the trick.</P><P></P><P>Many thanks</P><P>Geoff</P></BODY></HTML> Thu, 03 Jul 2014 15:08:39 GMT https://community.qlik.com/t5/QlikView/Using-Variable-in-Set-Analysis/m-p/707075#M254804 2014-07-03T15:08:39Z