topic inputsum not working in QlikView

inputsum not working

Wed, 15 Dec 2010 12:52:25 GMT

I have the following expression providing me with the forecast KG value:

Sum({$ <Forecast.ForecastType = {"KG"}, Forecast.ForecastVersion = {"Current"}>}Forecast.Value)

In order for the Forecast to be amended via QV i was hoping to use the following coding (and a few variations) but this doesn't appear to work.

inputsum(Sum({$ <Forecast.ForecastType = {"KG"}, Forecast.ForecastVersion = {"Current"}>}Forecast.Value) )

Please can you let me know what I am doing wrong.

Thanks, Gareth

inputsum not working

tseebach — Wed, 15 Dec 2010 13:18:14 GMT

You need to cast the field as inputfield in the script.

Add

inputfield Forecat.Value

to your script. I'd however advise you to precalculate the value of the field in the script, since having a set declaration might give unwanted results.

inputsum not working

Tue, 08 Mar 2011 15:36:20 GMT

Thanks