topic Loading problem with 10 Qlikwiew in QlikView

Loading problem with 10 Qlikwiew

francofiorillo — Mon, 01 Nov 2010 17:46:26 GMT

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

Loading problem with 10 Qlikwiew

pover — Tue, 02 Nov 2010 16:11:54 GMT

Are you using inputfields? I've had trouble with inconsistent script errors when using inputfields. I would just receive the "Script failed. Load previous data?" at the end of the script. I found that I have to load the script without inputfields first and then with inputfields for it to work.

Have you generated the script log files?

Regards.

Loading problem with 10 Qlikwiew

francofiorillo — Tue, 02 Nov 2010 17:56:19 GMT

Hello.
Yes, I use inputfields. I tried to upload the scripts without inputfields and the procedure is successful (although reloading several times). I put the two statments inputfields. the first loading is OK. the next they give me the same error as before and that I have to reload the previous data. I am attaching the file to load it on after the first time (when the error occurs again).
thank you very much for your cooperation.

Loading problem with 10 Qlikwiew

pover — Tue, 02 Nov 2010 18:29:08 GMT

Are you still looking for help or have you resolved your own question then?

Loading problem with 10 Qlikwiew

francofiorillo — Tue, 02 Nov 2010 18:54:37 GMT

Normal 0 14 false false false IT X-NONE X-NONE MicrosoftInternetExplorer4

no. I have not resolved. as I scritoo on the forum, if I remove the command inputfields everything is ok, but just put it back after an initial loading was successful, the problem returns.

sorry, the error occurs because there is an anomaly in QV10?
if so will be removed?
hello
thanks

Loading problem with 10 Qlikwiew

pover — Tue, 02 Nov 2010 19:01:52 GMT

This is a QV10 problem. The file I have works perfect in QV 9.

In QV10 there is also an error about duplicate inputfield key values that didn't exist in QlikView 9. You have to put a unique id in every row to fix that error. If you run into this problem use the rowno() function.

I haven't reported it as a bug to QlikTech yet. If you have a chance to report it, go ahead.

Regards.

Loading problem with 10 Qlikwiew

francofiorillo — Wed, 03 Nov 2010 08:33:52 GMT

thanks.
not very experienced, I did not understand what I do.
I can do a small example?
I'm sorry for the inconvenience.
hello

Loading problem with 10 Qlikwiew

pover — Wed, 03 Nov 2010 19:40:20 GMT

I've reported the problem to QlikTech support. I will keep you informed.

Regards.

Loading problem with 10 Qlikwiew

francofiorillo — Thu, 04 Nov 2010 07:49:56 GMT

Thank you for your cooperation.
Hello.

Loading problem with 10 Qlikwiew

Wed, 05 Jan 2011 13:39:13 GMT

Hello,

We were having problems with inputField too. We found that the script Works, all inputfields should be placed at the end of the Script.

We not find a logical explanation for this, but over all inputField to the end of the code the application without error in its charge.

open to comments!

Regards.

Loading problem with 10 Qlikwiew

tseebach — Fri, 07 Jan 2011 18:09:14 GMT

Hi, I'm experiencing the same issues. A bit differently however.

In my first script where I used Input Fields I get the "Duplicate keys when loading Input Field" message when reloading, where it fails.

In my other script, I don't get any errors in the load, however the InputSum() function display a "-" and their is no possibility to edit the values.

I've also reported the bug.

Loading problem with 10 Qlikwiew

pover — Fri, 07 Jan 2011 19:24:15 GMT

Two things you should consider when using inputfields:

1. The inputfield must be created after the table structure has been made stable. For example, you can't create an inputfield in a table and then join that table to another. Therefore, the creation of the inputfield should be the last operation done on a table.

2. In version 10, each row that contains an inputfield must have a unique indentifier. If one doesn't exist, you can create a field in QlikView using rowno() that will give each row a unique number.

Regards.

Loading problem with 10 Qlikwiew

Wed, 16 Feb 2011 15:12:13 GMT

using rowno() does not work, other solution?

Loading problem with 10 Qlikwiew

pover — Wed, 16 Feb 2011 18:32:21 GMT

Are you receiving the same error? It might be helpful if you post your script.

Regards.

Loading problem with 10 Qlikwiew

Mon, 21 Feb 2011 09:58:14 GMT

Hi,

I had the same error (duplicate key...) and rowno() worked fine for me.

Part of my script:

Inputfield FC_1, FC_T1;
load distinct
KEY_FC,
OT_Quartal as FC_Quartal,
0 as FC_1,
'y' as FC_T1,
RowNo() as ID
resident ontop;

Thanks for helping!

Cheers,

Tanja

Loading problem with 10 Qlikwiew

Thu, 03 Mar 2011 18:38:53 GMT


Torben Seebach wrote:
Hi, I'm experiencing the same issues. A bit differently however.
In my first script where I used Input Fields I get the "Duplicate keys when loading Input Field" message when reloading, where it fails.
In my other script, I don't get any errors in the load, however the InputSum() function display a "-" and their is no possibility to edit the values.
I've also reported the bug. <div></div>

I got the same problem and i didnt solve this. I´m using the 10.00.8715.5 (64bits) QV´s version.

Loading problem with 10 Qlikwiew

sukydhak — Thu, 17 Mar 2011 16:50:28 GMT

Guys

I can't get my input field to work with XLS. It works as expected with an inline table. Just hangs with xls. Any one knows how to fix this.

Attached is the sample document.

Suky

Loading problem with 10 Qlikwiew

Thu, 17 Mar 2011 17:40:52 GMT

Hello,

Replace the code for:

inputfield Commentxls;
table_xls_aux:
LOAD Key as Keyxls,
F2 as F2xls,
if(isnull(Commentxls)
,' '
,Commentxls) as Commentxls
FROM
table1.xlsx
(ooxml, embedded labels, table is Sheet1);

see ya

Loading problem with 10 Qlikwiew

erichshiino — Tue, 19 Apr 2011 01:29:26 GMT

Were you all able to make inputfield to work on QV 10 SR1?

I moved the inputfield definition to the end, but it didn't help.

I can use my field as regular field, but list boxes or straight tables do not allow me to change the number anymore.

Inputsum returns null for me in any case.

Please, I'd like to know more about your experiences.

Did you contact QlikTech support about it?

Rgds,

Loading problem with 10 Qlikwiew

pover — Tue, 19 Apr 2011 17:26:42 GMT

Hello Erich,

You have to define the inputfield before you load it or else it isn't defined as an inputfield. Inputfield works with v10 SR1, but there seems to be some changes in generating it.

What specific error are you getting?

Regards.