Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to split monthly volume for two days within one month?

Hi

I am trying to build a forecast report for accounts receivables. My sales forecast is only on monthly level and I would need to split that at least to two pieces. What kind of script I would need to write in following scenario:

Original table:

Product codeSales forecast March
1111110000
2222210000
3333310000

Desired table: 60% in 10th day and 40% in 20th day

Product codeSales forecast in March 10thSales forecast in March 20th
1111160004000
2222260004000
3333360004000

Thanks

Regards

Janne

Tags (2)
Community Browser