Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Rank function to suppress zero values

Hi all,

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.

Is there any way to solve this?

Thanks!

Stefan

2 Replies
Not applicable

Re: Rank function to suppress zero values

Try to use Dimension Limits( Dimension Limit Tab).

Choose show only "Smallest" 10 and in "Presentation tab" Uncheck ""Suppress Zero-values"

I think it will solve your problem.

Not applicable

Re: Rank function to suppress zero values

Unfortunatelly the customer is with v10 so dimension limits is not an option

Community Browser