topic Rank function to suppress zero values in QlikView https://community.qlik.com/t5/QlikView/Rank-function-to-suppress-zero-values/m-p/415473#M490544 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have an requrement that i should create a straight/pivoit table that should show worst 10 salesmans. I wrote an expression using rank function. But the problem is that rank ignore the suppress zero values check and the table show worst 10 salesmans but including the salesmans without any sales. Which must be excluded from the report.</P><P></P><P>Is there any way to solve this?</P><P></P><P>Thanks!</P><P>Stefan</P></BODY></HTML> Mon, 15 Oct 2012 12:00:02 GMT 2012-10-15T12:00:02Z Rank function to suppress zero values https://community.qlik.com/t5/QlikView/Rank-function-to-suppress-zero-values/m-p/415473#M490544 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have an requrement that i should create a straight/pivoit table that should show worst 10 salesmans. I wrote an expression using rank function. But the problem is that rank ignore the suppress zero values check and the table show worst 10 salesmans but including the salesmans without any sales. Which must be excluded from the report.</P><P></P><P>Is there any way to solve this?</P><P></P><P>Thanks!</P><P>Stefan</P></BODY></HTML> Mon, 15 Oct 2012 12:00:02 GMT https://community.qlik.com/t5/QlikView/Rank-function-to-suppress-zero-values/m-p/415473#M490544 2012-10-15T12:00:02Z Re: Rank function to suppress zero values https://community.qlik.com/t5/QlikView/Rank-function-to-suppress-zero-values/m-p/415474#M490545 <HTML><HEAD></HEAD><BODY><P>Try to use Dimension Limits( Dimension Limit Tab).</P><P></P><P>Choose show only "Smallest" 10 and in "Presentation tab" Uncheck ""Suppress Zero-values"</P><P></P><P>I think it will solve your problem. </P></BODY></HTML> Mon, 15 Oct 2012 12:20:20 GMT https://community.qlik.com/t5/QlikView/Rank-function-to-suppress-zero-values/m-p/415474#M490545 2012-10-15T12:20:20Z Re: Rank function to suppress zero values https://community.qlik.com/t5/QlikView/Rank-function-to-suppress-zero-values/m-p/415475#M490546 <HTML><HEAD></HEAD><BODY><P>Unfortunatelly the customer is with v10 so dimension limits is not an option <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Mon, 15 Oct 2012 12:24:10 GMT https://community.qlik.com/t5/QlikView/Rank-function-to-suppress-zero-values/m-p/415475#M490546 2012-10-15T12:24:10Z