Loading problem with 10 Qlikwiew

[francofiorillo]

Hello.
It happens to me a strange thing.
With the release of version 10, I started to try the applications already made.
I had no problem, except for an application for which I can not reload the script as though not getting any error message from the variables, and showing that you have loaded the data, in the end I said:
Running the script failed. Load the previous data?
I have tested.
1. I tried to load only part of the script. To a certain extent is fine, then randomly just add another sheet of the script gives me the error persists, oddly enough, even if I delete the package you just added.
2. I tried to export the presentation of the document and to import it into a new document. Well. The data load is successful only the first time, then I always get the same error.
I think there are dirty data. In the script, do not use anything special. Can I assume that would be the command RESIDENT (I have several).
Could you please give me a hint?

thanks in advance for your cooperation

[erichshiino]

I tried to define it at the beggining and also at the end (after I read some posts) but I didn't work.

They seem to be regular field and inputsum returns null but I don't get any error message during reload.

[pover]

Erich,

If you're still having trouble, upload your script for review.

Regards.

[#4]

That seems to be a small bug in QV10 but there are three important things that can help to make it work :

• Be sure that the table containing the input fields has a unique AND single key that relates it with the other tables
• If possible, disconnect the table from the other table
• Declare the input fields before using them in the script (LOAD,... etc.)

Some people here in the forum said that it may be helpful to use inputfields at the end of the script. I can't confirm that (at least for QV10).

Hope that helps !

Rupert

[eleni_theodorid]

Dear All,

I had the same problem for version 10 SR2 and I had solve it by using the Input Fields at the end of the script.

Best Regards,

Helen

[Anonymous]

But, this would drop your input on reload for the relevant record, if the rowno does not correspond to the data anymore, e.g. if you do not load that particular record, and load it again afterwards. Right?

[galrion82]

Hi.

Had the same problem - "Duplicate keys when loading Input Field"-  when i changed from Qv9 to QV10.

After adding rowno() to the table the script ran without problems.

10x a lot for the help.

[vgutkovsky]

Alecsandru, thanks for the tip, I would never have figured that out on my own!

[henrikkold]

Thank you Alecsadru, big help - quite difficult to guess that as a solution.

[#10]

Hi,

I had the same imput-field trouble and fixed it by using "RowNo()"

It's so simple procedure in my case.

I used a xlsx file as a data-source.

[Before]

LOAD storename,

     date,

     customer,

     price,

     amount,

FROM

data.xlsx

(ooxml, embedded labels, table is sales);

[After]

INPUTFIELD price, amount;

LOAD storename,

     date,

     price,

     amount,

     RowNo()

FROM

data.xlsx

(ooxml, embedded labels, table is sales);

I just added "RowNo()" to the end of Load-Statement.

[#11]

Sorry but I know that's a long time that anyone put something here but I'm new in this Community and I'm facing this problem in QV10.

I put InputField before and then in the end of the Script and It didn't work.

I have no problems by Reload but I can't put any value at my "InputField Field".

May you help me?

I've tried it in two ways.

The first one, I can't put any value in InputField

The second, If I put any value, it give an error like the image.

1 -

Priorização:

LOAD //Module as %Module,

     //Status as %Status,

     //[by Dept.],

     //[Reported by user],

     Number,

     //Subject,

     //Motivation,

     //[Prioridade Anterior],

     //[Current Responsible],

     Anterior,

     0 as Prioridade,

     RowNo()

FROM

[lalalalalalalalalala\Atualização.xlsx]

(ooxml, embedded labels, table is Sheet1);

INPUTFIELD Prioridade;

2 -

INPUTFIELD Prioridade;

Priorização:

LOAD //Module as %Module,

     //Status as %Status,

     //[by Dept.],

     //[Reported by user],

     Number,

     //Subject,

     //Motivation,

     //[Prioridade Anterior],

     //[Current Responsible],

     Anterior,

     0 as Prioridade,

     RowNo()

FROM

[lalalalalalalalalalalalalala\Atualização.xlsx]

(ooxml, embedded labels, table is Sheet1);