topic Re: InputField Duplicate Keys in QlikView

InputField Duplicate Keys

mbespartochnyy — Mon, 27 Mar 2017 19:39:59 GMT

Hello everyone,

I have a quite a weird thing happening in QlikView and I'm hoping that someone else seen this and knows what's going on. I have a simple script:

INPUTFIELD [AFP Code Input];

INPUTFIELD [Rate Input];

INPUTFIELD [Volume Input];

LOAD * INLINE [

    ID, AFP Code Input, Rate Input, Volume Input

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    11

    12

    13

    14

    15

];

When I run that script, I get "Duplicate keys when loading Input Field". If I have 14 IDs or 16 IDs, it runs fine. When I have 15 IDs, it counts 14 twice:

Even though the last number in the script is clearly 15 and not 14. Is there something magical about number 15?

Thanks,

Mikhail Bespartochnyy

Re: InputField Duplicate Keys

sunny_talwar — Mon, 27 Mar 2017 19:42:59 GMT

Can't say why Input Fields behave the way they do.... but this seems to be working (at least for the sample)

INPUTFIELD [AFP Code Input];

INPUTFIELD [Rate Input];

INPUTFIELD [Volume Input];

LOAD RowNo() as ID,

'' as [AFP Code Input],

'' as [Rate Input],

'' as [Volume Input]

AutoGenerate 15;

Re: InputField Duplicate Keys

mbespartochnyy — Mon, 27 Mar 2017 20:00:36 GMT

InputFields are the worst. Great concept but such a weird behavior, wasted so much time on this. Anyway, thanks for the alternative !

Mikhail B.

Re: InputField Duplicate Keys

sunny_talwar — Tue, 28 Mar 2017 02:04:47 GMT

I agree.... the functionality is very powerful, but not sure why it isn't looked after...

Re: InputField Duplicate Keys

jafari_ervin — Sun, 28 Oct 2018 15:08:20 GMT

please comment your input field command and reload then uncomment. everything will be correct;