Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Display top 'x' rows and sum others

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

Not applicable

Re: Display top 'x' rows and sum others

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".

Community Browser