Hi everyone,
I have a really simple question.
| DIVISION | Balance | Past Due | % Balance | % Past Due |
| A | $1,111,122.00 | $117,000.00 | 27.45% | 2.26% |
| B | $200,000.00 | $330,003.00 | 4.94% | 6.38% |
| C | $115,000.00 | $487,737.00 | 2.84% | 9.43% |
| D | $400,000.00 | $366,365.00 | 9.88% | 7.08% |
| E | $2,222,222.00 | $3,873,773.00 | 54.89% | 74.86% |
| Total | $4,048,344.00 | $5,174,878.00 | 100.00% | 100.00% |
The above Table has been created in Excel.
I have the Column name DIVISION, BALANCE and PAST DUE in Qlikview.
Now I want to add % Balance and % Past Due in the same table in Qlik as shown above.
NOTE: In excel its very easy to create a new column and add some formula to create relative percent as shown above.
Can anyone guide me to create the same in Qlikview?
Thanks,
H
