Forecasting problem with input field.

Sun, 10 Aug 2014 18:39:38 GMT

Hello ,

I am facing an issue related to forecasting by using input filed.

I am using input field for forecasting purpose,depending on the input values provided in the forecast table for joiner HC and Joiner ARC,I am calculating the Joiner HC and Joiner TRC with respect to the Opening HC and Opening TRC.

But i am not able to get the correct result at the total level for the Joiner ARC and Joiner TRC.

I am performing below computation:

1)Joiner HC= Opening HC * Joiner HC %(Provided in the forecast Table)

2)Joiner TRC=OpeningARC *(1+Joiner TRC%)(Provided in the forecast Table)

3)Joiner ARC= Joiner TRC/Joiner HC

Issue:

Joiner HC is giving - (NULL) if we are using expression total and provide correct result with the sum of rows but we require the expression total result to be correct as it is used in the computation of Joiner ARC.

Joiner TRC is giving - (NULL) if we are using expression total and provide correct result with the sum of rows but we require the expression total result to be correct as it is used in the computation of Joiner ARC.

Joiner ARC is giving - (NULL) if we are using expression total .

I am attaching the sample application with the expected result in the xls file.

Regards,

Shailja

topic Forecasting problem with input field. in QlikView

Forecasting problem with input field.