Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

inputsum not working

Hi

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

1 Solution

Accepted Solutions
tseebach
Luminary Alumni
Luminary Alumni

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.

View solution in original post

2 Replies
tseebach
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Thanks