topic Re: Using a Variable in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Using-a-Variable-in-Set-Analysis/m-p/389634#M145404 <HTML><HEAD></HEAD><BODY><P>You got it almost right.&nbsp; This works for me:</P><P>Sum <SPAN style="font-size: 8pt;">( {&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear</SPAN><SPAN style="font-size: 8pt;">={'$(vMonth)'}&gt;}&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Data</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Wed, 27 Feb 2013 16:55:46 GMT Anonymous 2013-02-27T16:55:46Z Using a Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-a-Variable-in-Set-Analysis/m-p/389633#M145403 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone help me with this pelase?</P><P></P><P>I have been working on a complex dashboard, and couldn't get a variable working in Set Analysis. I have done in the past, but for some reason this particualr one does not seem to work and I can work out why.</P><P></P><P>I've attached the example below. </P><P></P><P>I've got 2 table one I have manualy entered the value in the set analysis and the other I'm trying to get it from a Variable.</P><P></P><P>It works in one table but no the other.</P><P></P><P>Can some help please.</P><P></P><P>Cheers</P><P></P><P>Simon</P></BODY></HTML> Wed, 27 Feb 2013 16:53:45 GMT https://community.qlik.com/t5/QlikView/Using-a-Variable-in-Set-Analysis/m-p/389633#M145403 2013-02-27T16:53:45Z Re: Using a Variable in Set Analysis https://community.qlik.com/t5/QlikView/Using-a-Variable-in-Set-Analysis/m-p/389634#M145404 <HTML><HEAD></HEAD><BODY><P>You got it almost right.&nbsp; This works for me:</P><P>Sum <SPAN style="font-size: 8pt;">( {&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear</SPAN><SPAN style="font-size: 8pt;">={'$(vMonth)'}&gt;}&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Data</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Wed, 27 Feb 2013 16:55:46 GMT https://community.qlik.com/t5/QlikView/Using-a-Variable-in-Set-Analysis/m-p/389634#M145404 Anonymous 2013-02-27T16:55:46Z