Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thank you for your help.
I tried but it still doesn't work
At the beginning of the script I wrote QUALIFY *...
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
checked it... no problem using Inline statement, when I switch to SQL query, it doesn't work no more
hi,
Try this application
Deepak
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?
Hi
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
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.
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