Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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".