how to use inputfield

[#1]

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.

[#2]

mmm ok, thank you and let me know

Im going to try your suggestion...

[quiquehm]

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

[deepakk]

hi Present,

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

[deepakk]

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

[#6]

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

[#7]

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.

[deepakk]

hi

Inputfield with qualify

[#9]

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

[#10]

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

[#11]

I am having the same problem