topic AW:Re: AW:Re: AW:How using InputField in QlikView

How using InputField

Fri, 04 Mar 2011 15:45:32 GMT

Hi,

I have defined a field as an InputField (f.e. Field1), before any loads or selects statements.

After, I connect to a data source and I select some fields from a SQL Server table. One of these fields it is Field1.

I expect that when I put this input field into a table box I could edit a value inside it, but this isn't the behaviour ???

Why? Thanks

UPDATE:

After the select about Field1, I'm using this field to determine a sum field inside a load statement. In this case, is it right that Field1 doesn't behave as an input field?

Morevover, I have defined another field as an input field for another select statement and it functions correctly.

Thanks

AW:How using InputField

Fri, 04 Mar 2011 16:19:55 GMT

Hello,

it should work as you described it. Perhaps there is only a little detail wrong. To clarify this: are you able to send a little exam app?

Regards, Roland

AW:How using InputField

Fri, 04 Mar 2011 17:11:11 GMT

I'm using the Personal Edition. Is it enough the script?

AW:Re: AW:How using InputField

Fri, 04 Mar 2011 17:23:02 GMT

Doesn't matter. I am using a prof. version. With this I am able to read (and rewrite) your app.

AW:Re: AW:How using InputField

Fri, 04 Mar 2011 18:26:11 GMT

Ok, thanks, I attach the qvw file.

AW:Re: AW:How using InputField

Fri, 04 Mar 2011 19:32:20 GMT

Becareful, there´s a bug in the QV 10 SR1, See to http://community.qlik.com/forums/t/36247.aspx

AW:Re: AW:Re: AW:How using InputField

Sat, 05 Mar 2011 15:13:17 GMT

Hi Jr,

thank you for your advice.

Roland

AW:Re: AW:Re: AW:How using InputField

Sat, 05 Mar 2011 15:32:21 GMT

Hi,

I just took a look at your app. This is to mention: Inputfield-Names have to correspondent with a name of a QV-Field. NOT with a Source-Fieldname (eg fields within SQL). So use Fieldnames belonging to a load-statement.

InputField FirstUpdate; // can't work, missing the QV-Field
InputField DescrProgetto; // same as above
InputField BDG_Gest; // works --> see "Budget Gest" in your upper tablebox

Note: if you move with your cursor onto "Budget Gest" of your upper (or any other) tablebox you will see a little "left arrow" to indicate this is an input field.

AW:Re: AW:Re: AW:How using InputField

Mon, 07 Mar 2011 17:33:24 GMT

Hi, thanks, but I can edit "DescrProgetto" and not "FirstUpdate". DescrProgetto isn't into a load statement. And why I cannot edit a field specified only into a select statement (the load statement it seems a ripetitive one)?

Moreover, when I try to comment the input field and reload data I have an execution error that I cannot solve to uncomment the input field. Is it stable the Personal Edition?

AW:Re: AW:Re: AW:Re: AW:How using InputField

Mon, 07 Mar 2011 19:52:16 GMT

Hello again,

sorry, I wasn't precise enough. Inputfieldnames have to correspondent with Fieldnames of the (internal) QV-Tables. Independent wether they are generated: by a select without a preceding load (like "DescrProgetto" is) or within a load-statement. So I was wrong, "DescrProgetto" is a valid Inputfield.

The Personal Edition is (as QT-guys told us) 100% the same like prof. Editions. It is only a licence issue, not a technical. This is to say, your PE Vxy should have the same features (and bugs) like the according prof. Edition Vxy. I tried to rebuild your "bug" in a small example application, but in vain, it loads correctly after comment the inputfields. What is the error message for doing what?

AW:Re: AW:Re: AW:Re: AW:How using InputField

Tue, 08 Mar 2011 13:46:29 GMT

Guys,

What´s the QV´s version you are using?

AW:Re: AW:Re: AW:Re: AW:How using InputField

Tue, 08 Mar 2011 14:53:45 GMT

Hi,

but also FirstUpdate is into a SELECT statement; then there is a LOAD statement. Does the LOAD statement override the fields defined in the SELECT statement? I'm expecting that also FirstUpdate was an input field.

I'm using QV 10 Personal Edition. I hope that the bug is due to the particular edition, but so it is present also in the prof/enterp edition.

I attach the only error message returned: in English says that the script execution is failed and asks to load the preceeding data.

My app is already a simple and a sample app and I have tried to debug it unsuccessfully. Thanks

AW:Re: AW:Re: AW:Re: AW:How using InputField

Tue, 08 Mar 2011 15:06:40 GMT

An update.

I have create another qvw and I have copied in the script the connection statement, the select statement and the load statement referred to the ole db data source. No boxes are added.

I have declared three input field and I have executed the reload and I have no error. I have commented one of this definition and I have reloaded, but unsuccessfully. This is the bug. Morevover, I have tried to uncomment the input field declaration but the error isn't solved.

Bye.

AW:Re: AW:Re: AW:Re: AW:How using InputField

Tue, 08 Mar 2011 16:37:51 GMT

Another update.

The bug occurs when I comment the input declaration for a field (defined with an alias) into a LOAD statement. F.e., in my app, see BDG_Gest field defined as a sum. Is it possible to modify the script somehow to solve the script failure?

Thanks

AW:Re: AW:Re: AW:Re: AW:Re: AW:How using InputField

Wed, 09 Mar 2011 12:17:59 GMT

Hello again,

unfortunately I can't reproduce the error. But your description looks like a bug. I assume you are using QV10 SR1 (see mainmenu --> Help --> About Qlikview). Did you check what Jr posted above:

Becareful, there´s a bug in the QV 10 SR1, See to http://community.qlik.com/forums/t/36247.aspx

If you use the V10 IR, don't hesitate to update, else sorry, but it seems to be a bug.

AW:Re: AW:Re: AW:Re: AW:Re: AW:How using InputField

Thu, 10 Mar 2011 12:44:13 GMT

Ok thanks, also I think a bug.

I have installed the update (build 8815), opened my document and reloaded data. The error ISN'T solved!