topic how to use variable in set analysis in QlikView https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228215#M80271 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>i m going to use the set analysis for calculating sum(sales) based on the company</P><P>vcomp=getfieldselections(Company)</P><P>in set analysis,i want to use this variable as</P><P>=sum({$&lt;Company={(vComp)}&gt;}Sales)</P><P></P><P>its not give the output</P><P>how to use this..</P><P>could anyone help me..</P><P>thanks in advance</P></BODY></HTML> Tue, 05 Oct 2010 12:53:07 GMT 2010-10-05T12:53:07Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228215#M80271 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>i m going to use the set analysis for calculating sum(sales) based on the company</P><P>vcomp=getfieldselections(Company)</P><P>in set analysis,i want to use this variable as</P><P>=sum({$&lt;Company={(vComp)}&gt;}Sales)</P><P></P><P>its not give the output</P><P>how to use this..</P><P>could anyone help me..</P><P>thanks in advance</P></BODY></HTML> Tue, 05 Oct 2010 12:53:07 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228215#M80271 2010-10-05T12:53:07Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228216#M80272 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Always $( var ) then test as ... =sum({$&lt;Company={$(vComp)}&gt;}Sales) or =sum({&lt;Company={$(vComp)}&gt;}Sales)</P><P>good luck , Luis</P></BODY></HTML> Tue, 05 Oct 2010 13:01:01 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228216#M80272 llauses243 2010-10-05T13:01:01Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228217#M80273 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=Sum({&lt;Company = {$(vComp)}&gt;} Sales)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 05 Oct 2010 13:03:16 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228217#M80273 2010-10-05T13:03:16Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228218#M80274 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>that one also not working ya...</P><P>send me one sample example using company and sales....</P><P>here vcomp contains the list of selected companies with comma separator..</P><P>could you pls help me...</P><P>thanks in advance</P></BODY></HTML> Wed, 06 Oct 2010 05:06:45 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228218#M80274 2010-10-06T05:06:45Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228219#M80275 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>yea,its work fine...</P><P>only when the comapny name like xxxx,yyyy</P><P>but its not work for xxxx Ltd,yyyy ltd....</P><P>when i pass the company name directly like xxxx Ltd and yyyy ltd its not working fine</P><P>so i pass the name as within the [xxxx Ltd],[yyyy ltd] braces,it will return the value...</P><P>how to do this one in the variable</P></BODY></HTML> Wed, 06 Oct 2010 05:18:27 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228219#M80275 2010-10-06T05:18:27Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228220#M80276 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>Please see attached file.</P><P>I used variable vComp in expression. The value of vComp is seperated by comma.</P><P>Hope this one helps</P><P>Nadsky</P></BODY></HTML> Wed, 06 Oct 2010 05:19:58 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228220#M80276 2010-10-06T05:19:58Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228221#M80277 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I update my file. This now solves your problem with Company Name having more than one word. I use trigger event on saving company names to variable vComp</P><P>Regards</P></BODY></HTML> Wed, 06 Oct 2010 05:35:00 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228221#M80277 2010-10-06T05:35:00Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228222#M80278 <HTML><HEAD></HEAD><BODY><P>hi</P><P>thank you very much....</P><P>its working fine...</P><P>really its good...</P></BODY></HTML> Wed, 06 Oct 2010 05:47:08 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228222#M80278 2010-10-06T05:47:08Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228223#M80279 <HTML><HEAD></HEAD><BODY><P>I'm glad that I was able to help you.</P><P>Please mark the post as "Verified Answer" so that other members with the same problem might know which part of discussion sovles the issue.</P><P>Thanks and Good Luck!</P></BODY></HTML> Wed, 06 Oct 2010 05:52:17 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228223#M80279 2010-10-06T05:52:17Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228224#M80280 <HTML><HEAD></HEAD><BODY><P>hi...</P><P>now i m going to use the expression as</P><P>(sum(depreciation)*sum(profit)/sum(income))/sum(depreciation)</P><P>how to use this expression in the set analysis.....</P><P>could you pls help me</P><P>thanks in advance</P></BODY></HTML> Wed, 06 Oct 2010 06:04:24 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228224#M80280 2010-10-06T06:04:24Z how to use variable in set analysis https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228225#M80281 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Oh I remebered that formula <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P>Is this question still part of this thread - &gt; <A href="http://community.qlik.com/forums/t/34871.aspx">http://community.qlik.com/forums/t/34871.aspx</A></P><P>Better we talk this part in your previous thread so that users may not go astray with the topic <IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P><P>I'll going to reply on this link: <A href="http://community.qlik.com/forums/t/34871.aspx">http://community.qlik.com/forums/t/34871.aspx</A></P><P>Thanks</P><P></P></BODY></HTML> Wed, 06 Oct 2010 06:13:32 GMT https://community.qlik.com/t5/QlikView/how-to-use-variable-in-set-analysis/m-p/228225#M80281 2010-10-06T06:13:32Z