top 3

[#1]

i want a function that shows top values..as in top 5 or 10

plz write the syntax also

thanks

[ecolomer]

here you have an example

[qlikmsg4u]

for charts u can use dimension limits , for expressions u can use rank function.

Rank function in expression

it may be useful.

[sujeetsingh]

Use rank function

[#5]

In the chart properties-> dimension limit-> eable (limit ) and select 3

[#6]

Hi,

User Rank Function

like this

=aggr(if(rank(sum(Sales))<=3,[Sales Point]),[Sales Point])

[MK_QSL]

Check enclosed file for TOP 5.. Use 3 instead of 5.

[#8]

In case you using QV 11 use dimension limits.

as said earlier RANK will also solve your query.

[amit_saini]

Deepak ,

See the attachments.

Thanks,
AS