I have a dataset with two dimensions and one simple expression (count).
I need to add an expression that is the total of the counts within one of the dimensions. So this is what I have, with Aggregate1 defined as
Aggr(count(ID),Payband)
| Payband | Minimum Bands | Count1 | Aggregate1 |
| < 1.5 | 400000 | 44 | 44 |
| 1.5 - 2 | 400000 | 53 | 3215 |
| 1.5 - 2 | 500000 | 1451 | - |
| 1.5 - 2 | 600000 | 902 | - |
| 1.5 - 2 | 750000 | 470 | - |
| 1.5 - 2 | 1000000 | 288 | - |
| 1.5 - 2 | 1500000 | 51 | - |
What I need is two things. I need the 3215 to show for all of Payband, but then I also need to show the cumulative distribution as follows:
| 1.5 - 2 | 400000 | 53 | 3215 | 98% |
| 1.5 - 2 | 500000 | 1451 | 3215 | 53% |
| 1.5 - 2 | 600000 | 902 | 3215 | 25% |
| 1.5 - 2 | 750000 | 470 | 3215 | 11% |
| 1.5 - 2 | 1000000 | 288 | 3215 | 2% |
| 1.5 - 2 | 1500000 | 51 | 3215 | 0% |
Please please please can you let me know how to calculate these as expressions in qlikview.
Thanks,
Joe
