Basically what I understand is that you want to change p and d values to see the results.
You can use Input Boxes where you can assign a variable in the input box. So in the chart expression, you can multiply by the variable accordingly as below.
Input ox for vP
In the expression, vP*(600-400)
Yes, I had that thought as well. The problem is not about assigning values to the variables, but getting QlikView to create rows and assigning the correct values for each statement. I thought of doing it directly in expressions but then I realized it can probably only be done in the script.
Here's what I have so far:
for vBudgetYear = $(vFirstBudgetYear) to $(vLastBudgetYear)
$(vBudgetYear) AS DeliverYear,
ChurnGrossProfit * $(vChurn) AS ChurnGrossProfit,
DevelopmentGrossProfit * $(vDevelopment) AS DevelopmentGrossProfit,
AcquisitionGrossProfit * $(vAcquisition) AS AcquisitionGrossProfit
Resident Prolongation Where DeliverYear=$(vBudgetYear) - 1;
Sadly, it does not work.