topic Inputfield error in QlikView

Inputfield error

Thu, 26 May 2011 14:38:40 GMT

Hi,

When we are using the inputfield we are getting error as Duplicate Key using input field and relaod is getting failed.

Note: We are using the input field against the Resident table.

Any idea when we will be getting error.

We are using QlikView 10 version.

Inputfield error

Thu, 26 May 2011 15:30:55 GMT

Can you upload an QVW example?

Thanks,

Mickaël.

Inputfield error

brenner_martina — Thu, 26 May 2011 15:59:04 GMT

Hi,

at first, do you have version 10, SR2? Can you upload the part of your script? Remind, that inputfields can only entered in ONE table at the end of the script, like:

Data:

Load Field1,

...,

Field2 as Inputfield, // or 0 As Inputfield or '' As Inputfield

...

Resident Table;

Inputfield error

Thu, 26 May 2011 16:59:45 GMT

Hi there, I have run across the same script error, it basically means that you have two or more identical rows within the same table, causing qlikview to be confused on how to assign the same inputfield value to a number of those identical rows, it is impossible for qlikview to make that decision beause of the associative model. The solution I found is to aggregate the data by all the dimensions within the table, in order to guarantee one single row for each dimension combinations, like this:

inputfield Amount;

Load dim1, dim2, dimn, sum(Amount) as Amount

from A

group by dim1, dim2, dimn;

Notice the the group by statement can cause qlikview to use a lot of RAM memory when working with large amount of data, also, the reload time may degrade significantly.

Regards

Inputfield error

raghavsurya — Fri, 27 May 2011 08:19:23 GMT

Hi Ivan,

I had a similar issue during one of the application buildout. We later noticed that the field name we were declaring at inputfield had presence in more than one table and we had to rename the field name.

Please check for any duplication of field names.

Regards,

Raghav

Inputfield error

Fri, 27 May 2011 08:29:30 GMT

Thanks for your response Ivan

I am yet to check the data duplication. Will check and update u