Dear all
i am new to qlikview
i have some requirement like below
i have a table
| Model | Import | Export | Total |
| A | 0.00 | 62.78 | 62.78 |
| B | 77.83 | 35.17 | 113.00 |
| C | 0.00 | 86.96 | 86.96 |
| D | 0.00 | 0.90 | 0.90 |
| E | 1.39 | 0.01 | 1.40 |
| F | 122.35 | 61.09 | 183.44 |
| | 201.57 | 246.92 | 448.49 |
Requirement is like i have to calculate below expression
x=(33/(B's Total+C's Total)) * B's Import
and
y=(33/(B's Total+C's Total)) * C's Import
and then create a table like
| Model | Import | Export | Total |
| A | | | |
| B | x | | |
| C | y | | |
| D | | | |
| E | | | |
| F | | | |
| | | | |
Thanks in advance
Regards
Kushal Thakral
