Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
naveen341
Creator
Creator

Need Help with top 10 Sales

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)

 

 

NamesSales
ABC1
lfyf1
hvjk1
ABC/b2
gyjgu3
uhg;ig3
gyig'u4
lh5
ou15
gcl;5
;yig;ig5
yv'v6
ui'7
yg[ig7
gyig[7
ugui12
y'didi13
jskwl8
uwow9
os10
uohdc1

expected output

NamesSales
ABC1
lfyf1
hvjk1
ABC/b2
gyjgu3
uhg;ig3
gyig'u4
lh5
ou15
gcl;5
;yig;ig5
yv'v6
ui'7
yg[ig7
gyig[7
jskwl8
uwow9
os10

 

@rwunderlich @sunny_talwar

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

Labels (1)
1 Reply
rushikale0106
Contributor III
Contributor III

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