topic Re: Excluding a dimension in an expression in QlikView https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392150#M819293 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><STRONG>=Sum({&lt;GL_1={NSV}, Dimension=- {RFC}&gt;} Data)</STRONG></P><P></P><P>If you still get an error, ignore it (it's a known issue) and go ahead.</P></BODY></HTML> Mon, 28 Aug 2017 09:40:21 GMT tresB 2017-08-28T09:40:21Z Excluding a dimension in an expression https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392149#M819292 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Currently I'm trying to exclude a dimension in an expression.</P><P>I was told this would work with the "-" sign in front of the dimension, however I get an error.</P><P>Not sure what I'm doing wrong though</P><P></P><P>gr</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174834_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392149#M819292 tim_leijen 2020-11-25T16:16:04Z Re: Excluding a dimension in an expression https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392150#M819293 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><STRONG>=Sum({&lt;GL_1={NSV}, Dimension=- {RFC}&gt;} Data)</STRONG></P><P></P><P>If you still get an error, ignore it (it's a known issue) and go ahead.</P></BODY></HTML> Mon, 28 Aug 2017 09:40:21 GMT https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392150#M819293 tresB 2017-08-28T09:40:21Z Re: Excluding a dimension in an expression https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392151#M819294 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try like this</P><P>sum({&lt;GL-l={'NSV'}<STRONG>,Dimension-={'RFC'}</STRONG>&gt;}Data)</P></BODY></HTML> Mon, 28 Aug 2017 09:42:09 GMT https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392151#M819294 devarasu07 2017-08-28T09:42:09Z Re: Excluding a dimension in an expression https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392152#M819295 <HTML><HEAD></HEAD><BODY><P>Thanks! Allthough it still shows an error, it does work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 28 Aug 2017 09:43:04 GMT https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392152#M819295 tim_leijen 2017-08-28T09:43:04Z Re: Excluding a dimension in an expression https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392153#M819296 <HTML><HEAD></HEAD><BODY><P>you have syntax error in your set analysis. See the below</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/4076">A Primer on Set Analysis</A>‌</P><P><A href="https://community.qlik.com/qlik-blogpost/4430">Why is it called Set Analysis?</A></P></BODY></HTML> Mon, 28 Aug 2017 09:46:51 GMT https://community.qlik.com/t5/QlikView/Excluding-a-dimension-in-an-expression/m-p/1392153#M819296 Kushal_Chawda 2017-08-28T09:46:51Z