topic Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item? in QlikView

How to create Top 10 and Sum remaining non-Top 10 as one single line item?

Tue, 16 Dec 2014 08:33:47 GMT

Query: how to get the desired results from data below?

Data

RANK	CTPY	AMT
1	A	15
2	B	14
3	C	13
4	D	12
5	E	11
6	F	10
7	G	9
8	H	8
9	I	7
10	J	6
11	K	5
12	L	4
13	M	3
14	N	2
15	O	1

Desired results

RANK	CTPY	AMT
1	A	15
2	B	14
3	C	13
4	D	12
5	E	11
6	F	10
7	G	9
8	H	8
9	I	7
10	J	6
REMAINDER		15

Thanks!

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

Tue, 16 Dec 2014 08:46:34 GMT

Hi Shi,

this looks to be a straight table? If so you can use the dimension limits tab to display just the top 10 like this.

hope that helps

Joe

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

Tue, 16 Dec 2014 08:54:38 GMT

hi,

It can be done by setting dimention limit as 10,in dimention limit tab as said by Joe above.

you wrote--sum remaining non top 10 as one single line item---what do you mean by this.

do you want sum of remaining to come in one line.

If yes den do reply.

Thanks

sudhanshu shrivas

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

Tue, 16 Dec 2014 08:57:19 GMT

- Need the remaining to sum to one line

- Also need to show the total amounts i.e. Top 10 + Remainder = Total

Thanks!

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

Tue, 16 Dec 2014 08:59:42 GMT

Ensure you tick the 'show others' and 'show total' boxes on dimension limits and this should give you the desired result

hope that helps

Joe

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

Tue, 16 Dec 2014 09:04:47 GMT

Rightly said.

in dimension limits.You have show others.just check it and you wil get your desired resultt.

Thanks

S Shrivas

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

richard_chilvers — Tue, 16 Dec 2014 09:05:23 GMT

...and if its important, don't forget to use 'Remainder' as the label for the 'Show Others' total.

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

Tue, 16 Dec 2014 09:08:17 GMT

Good point, I forgot to add that

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

anbu1984 — Tue, 16 Dec 2014 09:09:19 GMT

Dimension: =If(Aggr(Rank(Sum(AMT)),CTPY)<11, CTPY,'Others')

Expr: Sum(AMT)

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

its_anandrjs — Tue, 16 Dec 2014 09:12:02 GMT

Hi,

All are right use Dimension limits for this go to

1. Chart properties >> Dimension Limits >> Select Largest >> and enter value 11

Check settings

And you get output like this way

Regards

Anand

Re: How to create Top 10 and Sum remaining non-Top 10 as one single line item?

raynac — Thu, 15 Feb 2018 19:52:52 GMT

This is very helpful, thank you for this great resource!

Does anyone happen know if you can also get a total/sum of the Top X, before printing the remainder??