Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have following data on straight table, i am creating a "list box" top 'x' rows and others should sum up.
Straight table:
FS | 732 |
Tec | 30 |
Me | 28 |
Other | 25 |
PS | 14 |
Edu | 10 |
Util | 6 |
Auto | 5 |
Con | 5 |
Gov | 5 |
Tel | 4 |
Hea | 3 |
Aer | 2 |
Agr | 2 |
Dive | 2 |
Man | 2 |
Retai | 2 |
Hos | 1 |
the result shoud come as follow:
FS | 732 |
Tec | 30 |
Me | 28 |
PS | 14 |
Edu | 10 |
Util | 6 |
Others | 58 |
can someone help me to get above result?
Thanks
If you are using qv 11 you can use dimension limitis.
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".