topic Re: Top 10 in QlikView

Top 10

emteam162 — Wed, 13 Jul 2016 09:18:26 GMT

Hi All,

I want display top 10 and how have more then 15 items

dim	item
a	25
b	10
c	12
d	78
e	16
f	15
g	67
h	3
m	9

i want this

dim	item
d	78
g	67
a	25
e	16
f	15

Many thanks for your help

Said

Re: Top 10

Anonymous — Wed, 13 Jul 2016 09:22:57 GMT

Hi,

You can go to properties->Dimension Limits. You can then check the "Restrict which values are displayed. . ."

You can then restrict which values are shown

Re: Top 10

Wed, 13 Jul 2016 09:23:00 GMT

right click the object -> dimension limit -> show only largest n values

Re: Top 10

migueldelval — Wed, 13 Jul 2016 09:23:38 GMT

Hi Said,

Yopu only need to go to tab (Dimension limits) and check in the first option.

Regards

Miguel del Valle

Re: Top 10

emteam162 — Wed, 13 Jul 2016 09:32:37 GMT

Yes, but is not enough for me

i want dispaly the best suppliers (10) who have delivered more than 15

Re: Top 10

Wed, 13 Jul 2016 09:36:37 GMT

Use expression to sort out suppliers who have delivered more than 15, then go to dimension limit -> show only largest n values Hope it works!

Re: Top 10

emteam162 — Wed, 13 Jul 2016 09:41:06 GMT

can you give me exemple please

Re: Top 10

arasantorule — Wed, 13 Jul 2016 09:41:16 GMT

Hi,

You can use the expression to count the no of products delivered and also restrict to more than 15 in the condition.

Then in dimension limit show first ten values. Now sort the "no of product delivered" to descending.

Thanks,

Re: Top 10

varshavig12 — Wed, 13 Jul 2016 09:43:50 GMT

dimension

= dim

expression

= if(Rank(item)<=10,item)

Re: Top 10

emteam162 — Wed, 13 Jul 2016 09:47:46 GMT

doesn't work

Re: Top 10

amit_saini — Wed, 13 Jul 2016 09:49:33 GMT

Try :

=IF(aggr(rank(sum(items)),dim)<=10,dim)

as your dimension.

Thanks,

Re: Top 10

amit_saini — Wed, 13 Jul 2016 09:51:34 GMT

See the attachment.

Thanks,

Re: Top 10

emteam162 — Wed, 13 Jul 2016 09:56:02 GMT

attached what I want

Re: Top 10

amit_saini — Wed, 13 Jul 2016 10:03:21 GMT

Yes than should be like this:

=IF(Aggr(Rank(SUM(items),15),dim)<=5,dim)

See the attachment.

Thanks,

Re: Top 10

sunny_talwar — Wed, 13 Jul 2016 10:30:44 GMT

May be this?

If(Sum({<Customer = {"=Rank(SUM(Sales),4)<=5"}>}Sales) >= 150, Sum({<Customer = {"=Rank(SUM(Sales),4)<=5"}>}Sales))

Re: Top 10

qlikview979 — Wed, 13 Jul 2016 10:58:25 GMT

Hi,

Try this may be this help full

T1:

load * Inline [

dim, item

a, 25

b, 10

c, 12

d, 78

e, 16

f, 15

g, 67

h, 3

m, 9

];

NoConcatenate

T2:

First 5

load

dim,

item

Resident T1 Order by item desc;

DROP Table T1;

Re: Top 10

qlikview979 — Wed, 13 Jul 2016 11:54:42 GMT

Hi Try this ,

you will get correct output,

If you want check my attached file

T1:

load * Inline [

dim, item

a, 25

b, 10

c, 12

d, 78

e, 16

f, 15

g, 67

h, 3

m, 9

];

Take Straight table

Dimention:- dim,item

Expression:- Sum(item)

Step1:-Goto Presentation tab Select item Hide colomn "item".

Step2:-Goto Select item Click on "Restrict which values are displayed using the first expression

Step3:-Select "Show only Values that are:"

Then select this "Greaterthenor Equal to, 15, Exact total

And remove show others