Pie Chart Showing Just top 10 Values

[#1]

Hi,

I am wondering how can I show on the graph top ten highest apps staff ID as below:

App ID	Staff ID
152647	1
324125	2
459778	1
1554971	4
1313131	2
6464466	1
464646	1
648747	4
799797	5
344343	1
4334341	2
634646	3
4584694	6
546464	1
4564647	6
469476476	4
64764646	8
5464646	9
644646	10
3533131	13
6421616	1
9310101	2
12198586	4
15087071	5
17975556	6
20864041	7
23752526	8
26641011	9
29529496	10
32417981	11
35306466	12
38194951	13
41083436	14
43971921	15
46860406	1
49748891	3

[MK_QSL]

see attached

Untick show others in dimension limit

[#3]

Could you please paste screenshot as I cant download attached file

[MK_QSL]

Here we go

[#5]

Apologies, I could not see Untick show others in dimension limit. Could you pleae tell step by step as I am new in Qlikview. I want top 10 highest apps staff Ids from 1 to 10 please

[ngulliver]

Hi, Shoaib.

Go to Properties for your Pie Chart. Go into the Dimension Limits tab. There you can select limits button and show largest 10 values.

Regards,

Neil

[MK_QSL]

RIght Click - New Sheet Object - Chart and Select Pie Chart

Dimension = Staff ID

Dimension Limit

Tick Restrict Which Values are .....

Show Only Largest 10

Option

Show Others = UNTICK

Expression 1

COUNT(DISTINCT [App ID])

Expression 2

IF(COUNT(DISTINCT [Staff ID])=1,'ID '&[Staff ID])

[#8]

Thanks Manish, I don't have Dimensions limit tabl but have presentation tab and there can select Max no of slices. So I selcted 10 so think it's showing top 10 values

[#9]

Thanks Neil, I don't have Dimensions limit tabl but have presentation tab and there can select Max no of slices. So I selcted 10 so think it's showing top 10 values

[MK_QSL]

may be because you are using older version on QlikView...

There is another way to do the same by using calculated dimension.

In a dimension, instead of Staff ID, type below... Rest are the SAME...

You will get exact the same result ...

=IF(Aggr(Rank(COUNT(DISTINCT [App ID])),[Staff ID])<=10,[Staff ID])