Adding Input Field to main data

Wed, 30 Nov 2011 12:23:26 GMT

Hi All

Is there a way I can add input field's total to actual data total based on an expression?

E.g.

Forecast Oct	Forecast Nov	Forecast Dec
100	20	30

Actual Oct	Actual Nov	Actual Dec
50	1000	300

I would like the expression to be based to Month(today()). So if Month(today())<Invoice month, then display Acutal, else display Forecast. So the expected should be:

Final Oct	Final Nov	Final Dec
50	20	30

Its 50 because Oct is passed and its 20 in Nov and 30 in Dec respectively because the invoice month is greater than this month.

Please help.

topic Adding Input Field to main data in QlikView

Adding Input Field to main data