topic Re: Problem with inputfields on qlikview 10 in QlikView

Problem with inputfields on qlikview 10

tduarte — Tue, 17 May 2011 09:43:06 GMT

We had an document on v8.5 that was having performace issues so we decided to have a go with QV10.

After reloading the document in QV10 I realized not everything was working, mainly the inputfields.

I found someone suggesting here that we should always had an unique ID to avoid issues with inputfields. So I used Rowno() in the table that contain the inputfield and it all looked fine. But it wasn't!

We load the inputfields with a default value of '0'. After a reload that value is keept but even if you save the document, close and then when you reopen it , the inputfield will have values from 0, 1, 2, 3, ... onwards...

It sets values to the inputfield just by closing an reopening the document.

Has anyone experienced this? Any ideas of what needs to be done to fix it?

Problem with inputfields on qlikview 10

ToniKautto — Tue, 17 May 2011 11:19:02 GMT

My initial guess is that your issue is related to the data set containing NULL values or data model contains synthetic keys, meaning that your chart object shows rows that do not really exist in your data. Your description sounds a bit strange though, so please attach a sample QVW to make evaluation of this a bit easier.

In case the app contains sensitive data, please use sfcrambling fucntion to make fields unreadable;

Settings > Document Settings > Scrambling

Also feel free to remove objects (company logos) that are not relevant to this problem, to make the app even more anonymous.

Problem with inputfields on qlikview 10

tduarte — Wed, 18 May 2011 12:06:35 GMT

Toni, I don't have any NULL values on any of the key fields of the table in question or any synthetic keys in the data model.

Basically I have 3 tables, each with a inputfield.

This is what I'm doing on the script:

Inputfield input_price1;

Table1:

Load

...

'0' as input_price1,

...

I then have a 3 pivot tables with an expression that will take the corresponding inputfield value if different from '0'.

The problem I'm having is only with one of the tables/inputfields.

I created a list box with the field input_price1 and after reload all values are '0' which is correct. So I save the document, close it and then when I open it again, the values change to 0,1,2,3,4....etc.. up to a bit more than the number of records.

How is that even possible?

Problem with inputfields on qlikview 10

ToniKautto — Wed, 18 May 2011 12:14:55 GMT

Please attach a sample QVW, to make it easier to evaluate.

Re: Problem with inputfields on qlikview 10

tduarte — Fri, 20 May 2011 11:50:28 GMT

I manage to find a temporary solution by storing into qvd the table that contains the inputfield with the issue, then dropping the table and then loading the table again from qvd later in the script.

It must be a problem with the links between the table or the pointers.

I have forwarded this to Support and will update later.

Re: Problem with inputfields on qlikview 10

tduarte — Mon, 13 Jun 2011 15:30:54 GMT

Reply from Support:

Thank you for bringing this problem to our attention. We have logged it

with our Issue Analysis team - ID 39541. If approved as a bug, the

issue will hopefully be fixed in the next Service Release.

I will advise you if there are any further developments in this regard.

Please accept our apologies for any inconvenience.

All I can do now is wait.

Re: Problem with inputfields on qlikview 10

tduarte — Mon, 04 Jul 2011 11:05:28 GMT

Hi all,

The paragraph below was taken from the QV10 SR3 release notes:

"Inputfields are not compatible with joins or resident loads.

The reason for this is that an inputfield must be read one time and one time only. Once

the inputfield is read it is added to an inputfield table and this table cannot be

tampered with. Joins affect the table and for that reason inputfields are disabled when

combined with joins. Resident works slightly different but it also affects the inputfield

table and it is disabled for the same reason."

I tried adding the input field only AFTER all joins or resident loads that use the table but that didn't work.

Input field was converted to a normal field so I don't get it.

Re: Problem with inputfields on qlikview 10

Anonymous — Thu, 07 Jul 2011 02:41:35 GMT

I've got the same exact problem. Please update this topic if you manage to find a solution.

Problem with inputfields on qlikview 10

hdonald — Tue, 26 Jul 2011 17:56:14 GMT

Hi,

Another method might be to create an in-memory table with just a key field and the input fields using a 'from' load, then rely on the associated join to use the input fields as before.

It means creating an extra table but it would at least put an explicit table in your data model that shows what is going on with the input fields.

This seems to work in my test environment - I'd be interested to know if anyone else is using the inputfields in this way,

Regards,

Problem with inputfields on qlikview 10

Anonymous — Tue, 26 Jul 2011 18:36:30 GMT

My problem turned out to be null values. However, this is not a problem in Developer. It's only when reloading via Publisher that these nulls cause a reload failure.

Re: Problem with inputfields on qlikview 10

tduarte — Wed, 27 Jul 2011 16:02:47 GMT

Hi HD,

Yes, exactly. I'm using the same method as suggest recently by support.

Inputfield MyInputField;

Data:

Load

RowNo() as InputKey

From data.csv;

InputField:

Load

RowNo() as InputKey,

'0' as MyInputField // sets 0 as default value in my case

AUTOGENERATE peek('InputKey', -1, 'Data');

It works.

Regards,

Telmo

Problem with inputfields on qlikview 10

hdonald — Wed, 27 Jul 2011 16:49:12 GMT

Telmo,

I was doing the load 'From data.csv' bit twice but that 'AUTOGENERATE peek(....' solution looks much neater, thanks for posting it,

Regards,

Problem with inputfields on qlikview 10

bob_zagars — Thu, 20 Oct 2011 16:16:16 GMT

Support,

We have determined in the Developer II training class for version 10 that SR3 is causing the problem with INPUTFIELD's. Several of the students had the same problem and other's did not after researching we found that the problem was only with SR3. The other students had SR1 and SR2. Hope this helps resolve this problem.

Regards,

Bob

Problem with inputfields on qlikview 10

amien — Tue, 13 Dec 2011 12:39:32 GMT

Thanks for this workaround

Anyone tested this with QV11 IR? cause from what i tested, it also didn't work

Problem with inputfields on qlikview 10

Fri, 03 Feb 2012 12:36:02 GMT

We have tested the problem in IR QlikView version 11 and also gives memory problem on the server reloads.

Is there any recommendation or limitation by the manufacturer?

Problem with inputfields on qlikview 10

Anonymous — Tue, 17 Apr 2012 10:17:48 GMT

I had the issue with v10 SR3.

When I opened the project in v9SR2 (because I have it as our previous version still on my machine), reloaded the data, saved the document and then opened it in v10SR3 everything was fine and I can edit the input field now.

Re: Problem with inputfields on qlikview 10

robert99 — Sun, 19 Aug 2012 10:10:09 GMT

Is there a problem with this recommended solution by support

In that if the load order changes then the comment is linked to a different record.

Its a great feature (inputfields) but this solution creates a risk in that its linked to a row (that can change the link to a record) not a record