Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Gopinathan
Contributor II
Contributor II

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.

0 Replies