Rank 10 highest values in a table with two dimensions

[helge_jorg]

Qlik experts

I would like to rank my measures to only show the 10 largest values in a table.

My dimesion is Date and [Navn]

The measure is avg({<ElementID= {TAX}>} [Verdi])

Thanks!

Cheers

Helge

[helge_jorg]

The uncheck "Include Zero Values" did it!

Thanks for the help, Sunny!

PS: There is only one measure, the other ones are date (year, month and day) and name dimensions.

[helge_jorg]

I have one additional question – how can rank the measures by lowest value? The measure includes negative values (ex. -42,80 degrees), depending on which month.

When I use this expression: If(Rank(TOTAL -Avg({<ElementID= {'TAX'}>} [Verdi])) < 11, -Avg({<ElementID= {'TAX'}>} [Verdi])) I get the rank as would like, but the negative value will then be displayed as a positive value.

[sunny_talwar]

Do this without the negative sign before your actual expression... keep the one within the Rank()

If(Rank(TOTAL -Avg({<ElementID= {'TAX'}>} [Verdi])) < 11, Avg({<ElementID= {'TAX'}>} [Verdi]))

[DirkPeterCasteleijn]

Hey Sunny,

I got the error: 'If-statement requires 2 or more parameters', and if i look to the expression this right. 

Is the expression you provided just the syntax of the expression itselve?