Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharathi09
Creator II
Creator II

Cost Calculation

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!!

0 Replies