topic how to use inputfield in QlikView

how to use inputfield

Wed, 15 Feb 2012 15:15:45 GMT

Hi all,

I am trying to use inputfield but it seems it doesn't work as I need.

According to the base guide, I have to declare something like:

INPUTFIELD Test.inputField;

Then I can declare my table. I used this one:

Test:
LOAD * 
Inline [
     var, inputField
     1, 1
];

After reloading, I can use that table and change every inputField value.

When I try to declare a table like the following, I can't change inputField value - that's the problem.

Test: 
LOAD *;
SQL SELECT * FROM table;

I need to change some values, and the table comes from a query.

I use QUALIFY and UNQUALIFY statement in my script. I can add a qvw file with a semplify example.

Last but not least: when an user edits a value, will the document save new value into its memory and then share new value with all users?

Thank you.

Re: how to use inputfield

Miguel_Angel_Baeyens — Wed, 15 Feb 2012 16:16:04 GMT

Hi,

Try just removing the table name from the INPUTFIELD sentence, and leave only the name of the actual field, case sensitive:

INPUTFIELD Field_1;
Table:
LOAD Field_1,
     Field_2;
SQL SELECT *
FROM Table;

Hope that helps.

Miguel

how to use inputfield

Wed, 15 Feb 2012 16:52:40 GMT

Thank you for your help.

I tried but it still doesn't work

At the beginning of the script I wrote QUALIFY *...

Re: how to use inputfield

Miguel_Angel_Baeyens — Wed, 15 Feb 2012 17:02:10 GMT

Hi,

My bad, then you do have to set the table name in the INPUTFIELD statement. Are you sure that you are spelling the field correctly? Does it appear case sensitive as you see it in the table viewer (Ctrl + T)? Note that some drivers are case insensitive about the name of the field and they send to the DBM all field names. QlikView does not work that way, and if the field name is uppercase, INPUTFIELD must specify the field uppercase.

Hope that helps.

Miguel

how to use inputfield

Wed, 15 Feb 2012 17:07:10 GMT

checked it... no problem using Inline statement, when I switch to SQL query, it doesn't work no more

Re: how to use inputfield

deepakk — Wed, 15 Feb 2012 19:21:07 GMT

hi,

Try this application

Deepak

Re: how to use inputfield

Thu, 16 Feb 2012 14:40:34 GMT

It works!

But no my document

What happens to you document if you use a script like this

Data:
SQL SELECT *, 1 as Test
FROM Testdata;

In more, I used OLEDB, I see you used ODBC: is this a problem?

how to use inputfield

quiquehm — Thu, 16 Feb 2012 15:29:37 GMT

Could someone share some more examples on how to use InputField ? I checked the Qview reference guide and the explanation there is really poor. I simply would need to add one InputField in an existing loaded table to appear as a Comments field, where I can manually enter a comment as needed for every row in my table.

Is there any other way to do it than using Load Inline statement ? I found an example , but using LOAD INLINE

INPUTFIELD Budget;

LOAD * INLINE [

Area, Actual, Budget

North, 10000

South, 20000

East, 30000

west, 40000

];

The example is really straight forward, but in my case the table where I need to add the manual entry field is already loaded ( from a flat file generated from another system ). Appreciate any help

Thanks

Enrique

Re: how to use inputfield

deepakk — Thu, 16 Feb 2012 21:28:18 GMT

hi,

The below are the steps forusing inputfield.

1) declare the field

inputfield Test; -------- here Test is the field name.

2) Use the field inthe table and initialize its value

Select *, 1 as Test from Table.

3)use it in expression of a pivot/ Straight Table

Inpustum(Test)

I hope this helps.

Re: how to use inputfield

deepakk — Thu, 16 Feb 2012 21:29:27 GMT

Hi Present02,

Try with ODBC in your system or create a resident of the table like below

Data:

Select * from TestTable;

Load * , 1 as Test residentData;

where Test is my inputfield.

I will try with OLEDB and let you know my result.

Deepak

Re: how to use inputfield

Fri, 17 Feb 2012 09:01:19 GMT

mmm ok, thank you and let me know

Im going to try your suggestion...

Re: how to use inputfield

quiquehm — Fri, 17 Feb 2012 12:01:12 GMT

Thanks a lot Deepak, now I understand a bit better how to setup the Inputfield ( in fact the reference guide should be more clear ).

The challenge I have is that the type of data I need to use as Inputfield is just free text ( manual entry comments ). I tried your instructions using '1' to initialize the value of the Inputfield ( in my case named as Comments ) and it works, no problem, you can change the values in a pivot table ( using Inputsum(Comments) as expression ) ..and it works ok, I even tried using '0' to initialize ..and it works perfect ...see above printscreen.

Do you know if it´s possible to enter free text in the Inputfield instead of numbers ? ( the only functions I found when used as expression are Inputsum and Inputavg ).When I try to enter anything different to numbers it does not accept it...simply puts a 0 ( or 1..if used as initial value ). I tried setting the Inputfield as a Dimension in my pivot table ( to try an enter free text there ) but it doesn´t work ( not even as a Calculated dimension using Inputsum ).

Appreciate any hint on this

Thanks again

Enrique

Re: how to use inputfield

deepakk — Fri, 17 Feb 2012 16:25:50 GMT

hi Present,

I tried with oledb and it seems to be working fine. PFA

Re: how to use inputfield

deepakk — Fri, 17 Feb 2012 16:28:59 GMT

hi Enrique,

I am not sure if you can add input text field in a pivot table. But you can do it a table box. In the above attach file on the right u will see a table box. You can input text into it and the respective changes will be seen in the pivot table.

Regards

Deepak

Re: how to use inputfield

Fri, 17 Feb 2012 16:31:19 GMT

Thank you for your help, I'm trying to edit your qvw file

Re: how to use inputfield

Fri, 17 Feb 2012 16:33:33 GMT

What about something like this script? May it work?

QUALIFY *;
INPUTFIELD newTable.a;
OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=tesAccess;DBQ=C:\Users\Deepu\Desktop\Community\Marketing Projects1.accdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"];
newTable:
LOAD a as AField; 
SQL SELECT 1 as a
FROM `C:\Users\Deepu\Desktop\Community\Marketing Projects1.accdb`.Testdata;

And this other script:

QUALIFY *;
INPUTFIELD newTable.a;
OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=tesAccess;DBQ=C:\Users\Deepu\Desktop\Community\Marketing Projects1.accdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"];
newTable:
LOAD a as AField; 
SQL SELECT fieldFromDB as a
FROM `C:\Users\Deepu\Desktop\Community\Marketing Projects1.accdb`.Testdata;

Thank you.

Re: how to use inputfield

deepakk — Fri, 17 Feb 2012 16:42:26 GMT

Inputfield with qualify

Re: how to use inputfield

Fri, 17 Feb 2012 17:11:43 GMT

Done! INPUTFIELD statement doesn't work when I use this code:

INPUTFIELD Table.Field;
LOAD field as Field;
SQL SELECT field FROM table;

it only works without as stament, so my code becomes:

INPUTFIELD Table.Field;
LOAD *;
SQL SELECT field as Field FROM table;

Thank you for your help

Re: how to use inputfield

Mon, 04 Feb 2013 07:29:14 GMT

Hi All,

I tried using the above attached .QVW file. It works fine in Qlikview Desktop. But when try this in Acces point, the change in value for the input field does not reflect. It always says 1. Does input field hold good for accesspoint.Can anyone help?

Regards

Abhishek

Re: how to use inputfield

Wed, 09 Jul 2014 18:50:38 GMT

I am having the same problem