topic Re: How to write the expression in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991016#M947447 <HTML><HEAD></HEAD><BODY><P>Just Click on 'Unprocessed'...see whether selection is happening.</P><P></P><P>Also make it fully compressed either by clicking on + sign or</P><P></P><P>Properties - &gt; Presentation - &gt; Always Fully Compressed(Left Bottom)</P></BODY></HTML> Mon, 28 Dec 2015 10:15:59 GMT Anonymous 2015-12-28T10:15:59Z How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991013#M947444 <HTML><HEAD></HEAD><BODY><P>I got a chart like below :</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/110010_Capture.PNG" style="height: auto;" /></P><P></P><P>By default , I don't want to show Precessed . so thus , I used the expression fo 'Sales Value'</P><P></P><P>sum({$&lt;TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales={'*'}-{'Processed'}&gt;} Amount) <IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/110011_Capture.PNG" style="height: auto;" /></P><P></P><P>Then getting the above chart, which is my requirement.</P><P></P><P>But , when I am trying to select 'Unprocessed' and 'Unspecified' then it is not selecting.</P><P></P><P>How can I select <SPAN style="font-size: 13.3333px;">'Unprocessed' and 'Unspecified' ?</SPAN></P></BODY></HTML> Mon, 28 Dec 2015 10:04:23 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991013#M947444 suvechha_b 2015-12-28T10:04:23Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991014#M947445 <HTML><HEAD></HEAD><BODY><P>With this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({$&lt;TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales <STRONG style="color: #ff6600;">-=</STRONG> {'Processed'}&gt;} Amount) </SPAN></P></BODY></HTML> Mon, 28 Dec 2015 10:11:08 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991014#M947445 Peter_Cammaert 2015-12-28T10:11:08Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991015#M947446 <HTML><HEAD></HEAD><BODY><P>would you be able to share the sample?</P></BODY></HTML> Mon, 28 Dec 2015 10:13:47 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991015#M947446 Kushal_Chawda 2015-12-28T10:13:47Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991016#M947447 <HTML><HEAD></HEAD><BODY><P>Just Click on 'Unprocessed'...see whether selection is happening.</P><P></P><P>Also make it fully compressed either by clicking on + sign or</P><P></P><P>Properties - &gt; Presentation - &gt; Always Fully Compressed(Left Bottom)</P></BODY></HTML> Mon, 28 Dec 2015 10:15:59 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/991016#M947447 Anonymous 2015-12-28T10:15:59Z