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