Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inputfield error

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.

5 Replies
Not applicable
Author

Can you upload an QVW example?

Thanks,

Mickaël.

brenner_martina
Partner - Specialist II
Partner - Specialist II

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;

Not applicable
Author

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

raghavsurya
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

Thanks for your response Ivan

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