Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Rename your THRESHOLD field and try . If problem still persist .. need to see the code.
Thanks
BKC
I get the following always:
i work on version SR8
try
TABLE:
LOAD * INLINE [
QUALITY_LEVEL, JOB_ID, THRESHOLD
QL1, X, 2
QL2, Y, 3
];
and see if you get the error?
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.
or try this
LOAD RowNo() AS Key,QUALITY_LEVEL,JOB_ID, THRESHOLD
INLINE [
QUALITY_LEVEL, JOB_ID, THRESHOLD
QL1, X, 2
QL2, X, 3
];
May be this post can help you
Hi
Have you managed to solve your problem
?
Sasi
Hi Can you upload your sample application? Thank you.