topic Re: How to use two set analysis in one expression ? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145286#M895755 <HTML><HEAD></HEAD><BODY><P>if you just want 1 sum instead of two and both expressions are identical (besdie actual, Budget)</P><P>you need to Change</P><P>Indicator_Type={'ACTUALS','BUDGET'}</P><P></P><P>then you can get rid of your second sum</P></BODY></HTML> Mon, 08 Aug 2016 12:47:52 GMT Anonymous 2016-08-08T12:47:52Z How to use two set analysis in one expression ? https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145284#M895753 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>How to use two set analysis in one expression ?</P><P><IMG alt="Exp.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133901_Exp.PNG" style="height: 296px; width: 620px;" /></P><P></P><P>Please help.</P><P>Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145284#M895753 2020-11-25T16:16:04Z Re: How to use two set analysis in one expression ? https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145285#M895754 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What exactly you trying to achieve? </P><P>Depending what you are trying to show it maybe possible.</P><P>I would advise first try the &amp; symbol between the expressions maybe &amp;'&nbsp;&nbsp; '&amp; to add some spaces.</P><P></P><P>Mark</P></BODY></HTML> Mon, 08 Aug 2016 12:43:06 GMT https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145285#M895754 Mark_Little 2016-08-08T12:43:06Z Re: How to use two set analysis in one expression ? https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145286#M895755 <HTML><HEAD></HEAD><BODY><P>if you just want 1 sum instead of two and both expressions are identical (besdie actual, Budget)</P><P>you need to Change</P><P>Indicator_Type={'ACTUALS','BUDGET'}</P><P></P><P>then you can get rid of your second sum</P></BODY></HTML> Mon, 08 Aug 2016 12:47:52 GMT https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145286#M895755 Anonymous 2016-08-08T12:47:52Z Re: How to use two set analysis in one expression ? https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145287#M895756 <HTML><HEAD></HEAD><BODY><P><IMG alt="exp1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133911_exp1.PNG" style="height: 54px; width: 620px;" /><IMG alt="exp2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/133912_exp2.PNG" style="height: 293px; width: 620px;" /></P><P>Thanks for your reply.</P><P>After adding &amp; between the expressions - 0 is being added before the value. How can i exclude that 0 ?</P></BODY></HTML> Mon, 08 Aug 2016 15:02:24 GMT https://community.qlik.com/t5/QlikView/How-to-use-two-set-analysis-in-one-expression/m-p/1145287#M895756 2016-08-08T15:02:24Z