topic Re: input fields in QlikView

input fields

ali_hijazi — Thu, 30 Jul 2015 11:36:03 GMT

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

Re: input fields

Thu, 30 Jul 2015 11:55:38 GMT

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

Re: input fields

Anonymous — Thu, 30 Jul 2015 12:03:18 GMT

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

Thanks

BKC

Re: input fields

ali_hijazi — Thu, 30 Jul 2015 12:07:50 GMT

I get the following always:

i work on version SR8

Re: input fields

sasiparupudi1 — Thu, 30 Jul 2015 12:15:45 GMT

try

TABLE:

LOAD * INLINE [

QUALITY_LEVEL, JOB_ID, THRESHOLD

QL1, X, 2

QL2, Y, 3

];

and see if you get the error?

Re: input fields

rubenmarin — Thu, 30 Jul 2015 12:18:51 GMT

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.

Re: input fields

sasiparupudi1 — Thu, 30 Jul 2015 12:20:32 GMT

or try this

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

INLINE [

QUALITY_LEVEL, JOB_ID, THRESHOLD

QL1, X, 2

QL2, X, 3

];

Re: input fields

sasiparupudi1 — Thu, 30 Jul 2015 12:29:13 GMT

May be this post can help you

Duplicate key and the Inputfield

Re: input fields

sasiparupudi1 — Sun, 02 Aug 2015 05:50:03 GMT

Have you managed to solve your problem

Sasi

Re: input fields

qlikviewwizard — Sun, 02 Aug 2015 06:21:20 GMT

Hi Can you upload your sample application? Thank you.