Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
francofiorillo
Partner - Creator
Partner - Creator

Loading problem with 10 Qlikwiew

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

31 Replies
erichshiino
Partner - Master
Partner - Master

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
Luminary Alumni
Luminary Alumni

Erich,

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

Regards.

Not applicable

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
Partner - Creator
Partner - Creator

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
Not applicable

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
Contributor III
Contributor III

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
Master II
Master II

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

henrikkold
Partner - Contributor II
Partner - Contributor II

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

Not applicable

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.

Not applicable

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);

Error.png