topic Re: set expression for this? in QlikView https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660283#M1082823 <HTML><HEAD></HEAD><BODY><P>Hyd <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 26 Jun 2014 10:32:35 GMT Anonymous 2014-06-26T10:32:35Z set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660275#M1082815 <HTML><HEAD></HEAD><BODY><P>I have productionID table ,&nbsp; there records like product( a)&nbsp;&nbsp; to&nbsp;&nbsp; product (z) fields&nbsp;&nbsp;&nbsp;&nbsp; in my front&nbsp; end when i click on product b and&nbsp; product c selections should not take .&nbsp; it should be hide remaining should be work ?&nbsp; how?</P></BODY></HTML> Thu, 26 Jun 2014 10:04:48 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660275#M1082815 2014-06-26T10:04:48Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660276#M1082816 <HTML><HEAD></HEAD><BODY><P>SUM({1}Sales)</P><P>or</P><P>SUM(ALL Sales)</P></BODY></HTML> Thu, 26 Jun 2014 10:05:59 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660276#M1082816 MK_QSL 2014-06-26T10:05:59Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660277#M1082817 <HTML><HEAD></HEAD><BODY><P>then use this expression:</P><P></P><P>sum({&lt;product={'*'}-{'b','c'}&gt;}value)</P><P></P><P>It helps.</P></BODY></HTML> Thu, 26 Jun 2014 10:09:49 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660277#M1082817 2014-06-26T10:09:49Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660278#M1082818 <HTML><HEAD></HEAD><BODY><P>Is this the same question as <A _jive_internal="true" href="https://community.qlik.com/thread/123384">http://community.qlik.com/thread/123384</A> which you posted five minures before?</P></BODY></HTML> Thu, 26 Jun 2014 10:24:00 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660278#M1082818 ThornOfCrowns 2014-06-26T10:24:00Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660279#M1082819 <HTML><HEAD></HEAD><BODY><P>sum({$&lt;productid=-{'b','c'}&gt;}measure)</P></BODY></HTML> Thu, 26 Jun 2014 10:25:47 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660279#M1082819 2014-06-26T10:25:47Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660280#M1082820 <HTML><HEAD></HEAD><BODY><P>difference is there between 2 queries</P></BODY></HTML> Thu, 26 Jun 2014 10:26:47 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660280#M1082820 2014-06-26T10:26:47Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660281#M1082821 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>like this sum({1-$&lt;Product={'b','c'}&gt;}Sales)</P><P></P><P>HTGH <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Ravi N.</P></BODY></HTML> Thu, 26 Jun 2014 10:28:51 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660281#M1082821 Anonymous 2014-06-26T10:28:51Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660282#M1082822 <HTML><HEAD></HEAD><BODY><P>correct brother.&nbsp; ekkada meeru undedhi</P></BODY></HTML> Thu, 26 Jun 2014 10:29:58 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660282#M1082822 2014-06-26T10:29:58Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660283#M1082823 <HTML><HEAD></HEAD><BODY><P>Hyd <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 26 Jun 2014 10:32:35 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660283#M1082823 Anonymous 2014-06-26T10:32:35Z Re: set expression for this? https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660284#M1082824 <HTML><HEAD></HEAD><BODY><P>denilo chesthunnaru</P></BODY></HTML> Thu, 26 Jun 2014 10:33:04 GMT https://community.qlik.com/t5/QlikView/set-expression-for-this/m-p/660284#M1082824 2014-06-26T10:33:04Z