Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

input fields

Hello

I want to use input fields

my script contains the following:

inputfield THRESHOLD;

TABLE:

LOAD * INLINE [

QUALITY_LEVEL, JOB_ID, THRESHOLD

QL1, X, 2

QL2, X, 3

];

qlikview is giving an error message saying duplicate key detected for input fields

Please advise

I can walk on water when it freezes
9 Replies
Not applicable

What version are you using? And is there any other code you have present?

I just ran that exact code with no issues, maybe you have the THRESHOLD field elsewhere in your application too?

Joe

Anonymous
Not applicable

Rename your THRESHOLD field and try . If problem still persist .. need to see the code.

Thanks

BKC

ali_hijazi
Partner - Master II
Partner - Master II
Author

I get the following always:

Untitled.png

i work on version SR8

I can walk on water when it freezes
sasiparupudi1
Master III
Master III

try

TABLE:

LOAD * INLINE [

QUALITY_LEVEL, JOB_ID, THRESHOLD

QL1, X, 2

QL2, Y, 3

];

and see if you get the error?

rubenmarin

Hi Ali, just that piece of code should work.

That message means there will be another table loading more rows where QUALITY_LEVEL and JOB_ID has the same values. Each row for the input field must have a unique combination of key values.

In example, this will fail:

inputfield THRESHOLD;

TABLE:

LOAD * INLINE [

QUALITY_LEVEL, JOB_ID, THRESHOLD

QL1, X, 2

QL2, X, 3

QL2, X, 4

];

The combination QL2, X should have only one row.

sasiparupudi1
Master III
Master III

or try this

LOAD RowNo() AS Key,QUALITY_LEVEL,JOB_ID, THRESHOLD

INLINE [

QUALITY_LEVEL, JOB_ID, THRESHOLD

QL1, X, 2

QL2, X, 3

];

sasiparupudi1
Master III
Master III

May be this post can help you

Duplicate key and the Inputfield

sasiparupudi1
Master III
Master III

Hi

Have you managed to solve your problem

?

Sasi

qlikviewwizard
Master II
Master II

Hi Can you upload your sample application? Thank you.