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

[#2]

In a dimension where should type. Application_ID is the primary key.

[israrkhan]

Hi Shoaib,

Make sure , you are not in Gauge Chart???

and let us know which version of qlikview are u using..?

because in 11, there are dimensions limits..

[#4]

Hi Israr,

No I am in pie chart. I am using vversion 9.00.7.440.8 SR3. which versiob should I use?

[MK_QSL · Accepted solution]

Try to download latest version and install in your PC.

Click on Add Calculated Dimensions and add below

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

Replace your field name Application_ID ....

[israrkhan]

Hi Shoaib,

Dimension limits are not in version 9,

if possible, update to version 11 sr2.

if cant update, than use, calculated dimension as below expression

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

[#7]

Thanks Israr.

[#8]

I will, Thanks Manish

[MK_QSL]

Dear Shoaib,

Can you select Correct Answer if your requirement fulfilled so that I can have point rewards.

Thanks...

[#10]

Manish,

Your and Israr's answers is the same. Can I not select both as correct?

[israrkhan]

Hi Shoaib,

i am not here for points...

i am here to learn and help others..points were never important for me..

Israr Khan