Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.