Hello All,
I have one requirement in Qlik
- Sum of Column R when Column B = '2452' and Column A = 'ij' = $141.52.
and multiplying that by monthly forecasted volume in the standars
Column R is COST_AVG, Column B is PTYear, A is Type
This calculation whole is for incorporating COST for MODE='RCJS' as we don't have data before
This is my existing qlik script how to get that RCJS mode related Data in application?
| PtYear |
August |
September |
October |
November |
December |
January |
February |
March |
April |
May |
June |
July |
| 2452 |
112 |
113 |
226 |
156 |
123 |
9 |
0 |
8329 |
556 |
337 |
228 |
117 |
| 2459 |
113 |
117 |
223 |
132 |
161 |
189 |
556 |
2365 |
187 |
234 |
115 |
197 |
| 2462 |
114 |
19 |
224 |
112 |
171 |
187 |
178 |
2342 |
114 |
256 |
115 |
116 |
Above is monthly forecasted date
Please help!!
