topic top 3 in QlikView

top 3

Fri, 05 Sep 2014 08:14:59 GMT

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

plz write the syntax also

thanks

ecolomer — Fri, 05 Sep 2014 08:15:58 GMT

here you have an example

qlikmsg4u — Fri, 05 Sep 2014 08:16:43 GMT

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

it may be useful.

sujeetsingh — Fri, 05 Sep 2014 08:17:48 GMT

Use rank function

Fri, 05 Sep 2014 08:19:03 GMT

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

Fri, 05 Sep 2014 08:26:34 GMT

Hi,

User Rank Function

like this

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

MK_QSL — Fri, 05 Sep 2014 08:30:23 GMT

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

Fri, 05 Sep 2014 08:33:54 GMT

In case you using QV 11 use dimension limits.

as said earlier RANK will also solve your query.

amit_saini — Fri, 05 Sep 2014 08:35:43 GMT

Deepak ,

See the attachments.

Thanks,
AS