Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Gopinathan
New Contributor

Contribution of forecast based on actual

Hi,

I would like to distribute the total forecast value based on the actual contribution as well as the user defined contribution.

I have Prod category A,B,C having sales 100,300 and 50, their contribution is 22%,67% and 11% respectively.

user will input the total forecast sales as 1000, than distribute the total based on the actual contribution. Lets say, now user wants to overwrite the prod category A to 25%, than Prod Cat A to 250, remaining 750 will be assign to the actual proportion to B and C. 

Prodsale% ContrForecastForecast
 450110001000
A1000.222222222.2222250(1000*25/100)
B3000.666667666.6667642.857143(750*(300/(300+50)
C500.111111111.1111107.142857(750*(50/(300+50)

 

Similarly, if the user input 25% to A and 50% to B than assign remaining to C. users will input the A,B and C values in different combinations. 

Thanks in advance.