topic Re: How to remove unnecessory values? in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-unnecessory-values/m-p/665993#M1053373 <HTML><HEAD></HEAD><BODY><P>Hi Priyantha,</P><P></P><P>1. Try with set analysis in a straight chart,</P><P></P><P>only({&lt;<SPAN style="color: #363636;">ORC_COM_DIFF={"&lt;0"}&gt;}<SPAN style="color: #363636;">ORC_COM_DIFF)</SPAN></SPAN></P><P> </P><P> </P><P> </P><P><SPAN style="color: #363636;">2. or in your load statement you can try like this</SPAN></P><P> </P><P><SPAN style="color: #363636;">Load * </SPAN></P><P><SPAN style="color: #363636;">from table 1</SPAN></P><P><SPAN style="color: #363636;">where <SPAN style="color: #363636;">ORC_COM_DIFF &lt; 0;</SPAN></SPAN></P><P> </P><P><SPAN style="color: #363636;">Regards</SPAN></P><P><SPAN style="color: #363636;">KC</SPAN></P></BODY></HTML> Tue, 21 Oct 2014 03:07:33 GMT jyothish8807 2014-10-21T03:07:33Z How to remove unnecessory values? https://community.qlik.com/t5/QlikView/How-to-remove-unnecessory-values/m-p/665992#M1053372 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>My table is like this.</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>BCOD</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ORC_CODE</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>REF_NO</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>POL_NO</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>CLA_CODE</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ORC_COM_DIFF</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="29"><SPAN style="color: #363636;">BA00</SPAN></TD><TD bgcolor="#ffffff" rowspan="28"><SPAN style="color: #363636;">6297</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028206</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00101A000875</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028209</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141D0003297</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028218</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00131F001678</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028224</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00071C000841</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028248</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141X0000270</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028250</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141X0000271</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-77</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028251</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00061C000749</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028252</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00081F001144</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028270</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141C0001572</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-413</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028275</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00131B002391</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028327</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141W0000097</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028332</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">04BA1B000300</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028340</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0006HC000026</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FR</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">189</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028346</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00121A001111</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028354</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141X0000285</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028384</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014SS0000295</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">SS</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-54</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028390</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0011CF001000</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FR</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028392</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0008TC001454</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">90</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028430</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00071C000852</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028440</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141D0003303</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028442</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00081F001147</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028449</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141F0001704</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028456</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0010GT000151</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MS</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028457</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0008CF000901</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FR</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">35</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028471</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00141C0001578</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028495</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00131D003156</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014D0028496</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00111F001588</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA0014R0064057</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BA00131A001226</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">MC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #ff3636;">-0</SPAN> </TD></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"><STRONG>Total </STRONG></TD><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"><SPAN style="color: #ff0000;"><STRONG>-172</STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P>If I want to show only the minus values, how can I do that?</P><P></P><P>Regards,</P><P></P><P>Priyantha.</P></BODY></HTML> Tue, 21 Oct 2014 02:49:11 GMT https://community.qlik.com/t5/QlikView/How-to-remove-unnecessory-values/m-p/665992#M1053372 2014-10-21T02:49:11Z Re: How to remove unnecessory values? https://community.qlik.com/t5/QlikView/How-to-remove-unnecessory-values/m-p/665993#M1053373 <HTML><HEAD></HEAD><BODY><P>Hi Priyantha,</P><P></P><P>1. Try with set analysis in a straight chart,</P><P></P><P>only({&lt;<SPAN style="color: #363636;">ORC_COM_DIFF={"&lt;0"}&gt;}<SPAN style="color: #363636;">ORC_COM_DIFF)</SPAN></SPAN></P><P> </P><P> </P><P> </P><P><SPAN style="color: #363636;">2. or in your load statement you can try like this</SPAN></P><P> </P><P><SPAN style="color: #363636;">Load * </SPAN></P><P><SPAN style="color: #363636;">from table 1</SPAN></P><P><SPAN style="color: #363636;">where <SPAN style="color: #363636;">ORC_COM_DIFF &lt; 0;</SPAN></SPAN></P><P> </P><P><SPAN style="color: #363636;">Regards</SPAN></P><P><SPAN style="color: #363636;">KC</SPAN></P></BODY></HTML> Tue, 21 Oct 2014 03:07:33 GMT https://community.qlik.com/t5/QlikView/How-to-remove-unnecessory-values/m-p/665993#M1053373 jyothish8807 2014-10-21T03:07:33Z Re: How to remove unnecessory values? https://community.qlik.com/t5/QlikView/How-to-remove-unnecessory-values/m-p/665994#M1053374 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>If(Expression &lt; 0, Expression)</P><P></P><P>Note: Replace Expression with your actual expression (Ex.Sum(<SPAN style="color: #363636; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ORC_COM_DIFF)), hope this helps you.</SPAN></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 21 Oct 2014 03:34:11 GMT https://community.qlik.com/t5/QlikView/How-to-remove-unnecessory-values/m-p/665994#M1053374 jagan 2014-10-21T03:34:11Z