topic Re: Can't suppress zero values when using rank function in QlikView https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531655#M1129227 <HTML><HEAD></HEAD><BODY><P>can you post QVW?</P></BODY></HTML> Wed, 04 Dec 2013 22:34:48 GMT MK_QSL 2013-12-04T22:34:48Z Can't suppress zero values when using rank function https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531652#M1129224 <HTML><HEAD></HEAD><BODY><P>I'm using the Rank function below so if the value of Quantity is not 0 then the rank function is used but if the value of Quantity is zero then zero is used.&nbsp; I've checked the "Suppress Zero-Values" on the Presentation tab so these rows should be hidden.&nbsp; This is not working when the rank function is used.</P><P></P><P><SPAN style="font-size: 8pt;">=if(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Quantity]</SPAN><SPAN style="font-size: 8pt;"> &lt;&gt; 0,rank(sum(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[qty-prod]</SPAN><SPAN style="font-size: 8pt;">)),0) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Here is an example of my table.&nbsp; The Row's displaying all zeros should not be displayed.</SPAN></P><P></P><P></P></BODY></HTML> Wed, 04 Dec 2013 22:06:53 GMT https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531652#M1129224 Anonymous 2013-12-04T22:06:53Z Re: Can't suppress zero values when using rank function https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531653#M1129225 <HTML><HEAD></HEAD><BODY><P>Could you please post your example?</P></BODY></HTML> Wed, 04 Dec 2013 22:09:42 GMT https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531653#M1129225 MK_QSL 2013-12-04T22:09:42Z Re: Can't suppress zero values when using rank function https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531654#M1129226 <HTML><HEAD></HEAD><BODY><P>Here is an example of the table in Excel.</P></BODY></HTML> Wed, 04 Dec 2013 22:14:20 GMT https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531654#M1129226 Anonymous 2013-12-04T22:14:20Z Re: Can't suppress zero values when using rank function https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531655#M1129227 <HTML><HEAD></HEAD><BODY><P>can you post QVW?</P></BODY></HTML> Wed, 04 Dec 2013 22:34:48 GMT https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531655#M1129227 MK_QSL 2013-12-04T22:34:48Z Re: Re: Can't suppress zero values when using rank function https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531656#M1129228 <HTML><HEAD></HEAD><BODY><P>Here is an example QVW.</P></BODY></HTML> Wed, 04 Dec 2013 23:06:11 GMT https://community.qlik.com/t5/QlikView/Can-t-suppress-zero-values-when-using-rank-function/m-p/531656#M1129228 Anonymous 2013-12-04T23:06:11Z