topic Re: InputSum problem in QlikView

InputSum problem

Mon, 11 Nov 2013 16:49:53 GMT

Hey All,

I'm looking to use input sum on a field. When I load a single table with a field set as an InputField this works fine. When I add a second table that is loaded from my initial table I can no longer get the InputSum field to work properly.

Please see the attached file. In it's current form you can see that my InputSum field is not working. If you go to the load script and comment out the loading of TestTable2 and then reload you will see that the InputSum field starts to work.

How can I get InputSum to work while also using my table to load another table?

Thanks,
Ken

Re: InputSum problem

swuehl — Mon, 11 Nov 2013 17:02:43 GMT

Ken,

please check Inputfields and SR3

for a possible workaround.

Re: InputSum problem

Mon, 11 Nov 2013 17:29:07 GMT

The workaround suggested there worked for me (loading my table to a QVD and then reloading it into my document). This is quite an odd workaround though and would make my load scripts difficult to understand if I have many InputFields over multiple tables.

Do you know why doing a resident load breaks the InputField as in my example? Is this a bug or a feature?

Thank you!

Re: InputSum problem

swuehl — Mon, 11 Nov 2013 17:36:12 GMT

Here you can find support's explanation (so to speak) for this issue and another workaround:

Problem with inputfields on qlikview 10