topic Need Help with top 10 Sales in QlikView

Need Help with top 10 Sales

naveen341 — Sat, 16 Nov 2024 00:43:02 GMT

Hi Team

i Have a Data as shown in below table

Sum(Sales) by Name is my straight table.

NOw i want to show top 10 sales.

Sow top 10 should be based on sales.Expected result(bottom Chart)

Names	Sales
ABC	1
lfyf	1
hvjk	1
ABC/b	2
gyjgu	3
uhg;ig	3
gyig'u	4
lh	5
ou1	5
gcl;	5
;yig;ig	5
yv'v	6
ui'	7
yg[ig	7
gyig[	7
ugui	12
y'didi	13
jskwl	8
uwow	9
os	10
uohdc	1

expected output

Names	Sales
ABC	1
lfyf	1
hvjk	1
ABC/b	2
gyjgu	3
uhg;ig	3
gyig'u	4
lh	5
ou1	5
gcl;	5
;yig;ig	5
yv'v	6
ui'	7
yg[ig	7
gyig[	7
jskwl	8
uwow	9
os	10

@rwunderlich @sunny_talwar

@marcus_sommer,@Oleg_Troyansky , @sunny_talwar,@rubenmarin ,

Re: Need Help with top 10 Sales

rushikale0106 — Fri, 17 Jul 2020 12:32:04 GMT

Hi @naveen341 ,

The solution you are seeking for sorting the data as per the ascending order with only the top 10 results can be found as below:

1. After creating a straight table, with Dimension as Names and Expression as sum(Sales). Go to Dimension Limit tab. On the left side, you will see your Dimension, Names selected.

2. There Check the box for 'Restrict which values are displayed using the first expression'. And select the first option with 'Show only'.

3. Select 'Largest' from the drop-down. And enter 10 in the next text box.

4. You can keep the Show others option from bottom options if you want to see remaining data.

5. Press Ok.

You will get your output as you expected. Let me know if you face any other issue.

Regards,

Rushi