topic Re: Exclude 0 in QlikView https://community.qlik.com/t5/QlikView/Exclude-0/m-p/1232631#M851716 <HTML><HEAD></HEAD><BODY><P>hi </P><P>have a look at the example ,</P><P>i changed the dimension in the summary table </P><P>and checked suppress null values</P></BODY></HTML> Mon, 06 Mar 2017 07:58:11 GMT lironbaram 2017-03-06T07:58:11Z Exclude 0 https://community.qlik.com/t5/QlikView/Exclude-0/m-p/1232630#M851715 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Please refer to the attachment, how to apply below <STRONG>Product</STRONG> condition into <STRONG>Grade</STRONG><SPAN style="font-size: 13.3333px;"> expression </SPAN></P><P><STRONG style="font-size: 13.3333px;">Product:</STRONG></P><P>=if(aggr(sum(QtySold),Product) &lt;&gt;0&nbsp; and aggr(sum(Sales),Product)&lt;&gt;0,Product)</P><P></P><P><STRONG>Grade:</STRONG></P><P>=aggr(if( rangesum(above(TOTAL (Sum({&lt;Product&gt;} Sales)/Sum(TOTAL {&lt;Product&gt;} Sales)),0,RowNo(Total)))&lt;=0.6,'A Stocks',if(</P><P>&nbsp; rangesum(above(TOTAL (Sum({&lt;Product&gt;}Sales)/Sum(TOTAL {&lt;Product&gt;} Sales)),0,RowNo(Total)))&gt;0.6 and rangesum(above(TOTAL (Sum({&lt;Product&gt;} Sales)/Sum(TOTAL {&lt;Product&gt;} Sales)),0,RowNo(Total)))&lt;=0.9,'B Stocks',</P><P>&nbsp; 'C Stocks'</P><P>&nbsp; )</P><P>&nbsp; ),Product)</P><P></P><P><STRONG>Note:</STRONG> my case i can't use suppress 0 value (Presentation tab because summary report won't work)</P><P></P><P>Thank,Dev</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exclude-0/m-p/1232630#M851715 devarasu07 2020-11-25T16:16:04Z Re: Exclude 0 https://community.qlik.com/t5/QlikView/Exclude-0/m-p/1232631#M851716 <HTML><HEAD></HEAD><BODY><P>hi </P><P>have a look at the example ,</P><P>i changed the dimension in the summary table </P><P>and checked suppress null values</P></BODY></HTML> Mon, 06 Mar 2017 07:58:11 GMT https://community.qlik.com/t5/QlikView/Exclude-0/m-p/1232631#M851716 lironbaram 2017-03-06T07:58:11Z