Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display top 'x' rows and sum others

Hello,

I have following data on straight table, i am creating a "list box" top 'x' rows and others should sum up.

Straight table:

FS732
Tec30
Me28
Other25
PS14
Edu10
Util6
Auto5
Con5
Gov5
Tel4
Hea3
Aer2
Agr2
Dive2
Man2
Retai2
Hos1

the result shoud come as follow:

FS732
Tec30
Me28
PS14
Edu10
Util6
Others58

can someone help me to get above result?

Thanks

2 Replies
Not applicable
Author

If you are using qv 11 you can use dimension limitis.

Not applicable
Author

This is a new feature in QV 11 that is Dimension limits.

Use can see this scenerio in the application "Whats New in QlikView11" in the tab "Sales Reps".