Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Bharathi09
Creator II
Creator II
‎2024-07-23 10:36 AM

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

423 Views
0 Replies