topic Re: Is it possible to set editable fields? in QlikView

Is it possible to set editable fields?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created a template with text fields, they are configure to bring data from a column in a database. Is there any way that I can update the text just typing on the field?

For example, I have a field with the description if I saw a misspelled word, and I want to correct it or add further information (doesn't need to get updated in database just in the displaying fields).

Thanks in advanced for your help.

Re: Is it possible to set editable fields?

Anil_Babu_Samineni — Thu, 13 Oct 2016 14:16:42 GMT

Try This

If(Field, ValueList(Field, '*****') = '*****', 'RequiredName')

Re: Is it possible to set editable fields?

vishsaggi — Thu, 13 Oct 2016 14:29:03 GMT

Did you try using Inputfield ? Check below ?

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptPrefixes/Inputfield.htm

Re: Is it possible to set editable fields?

rupamjyotidas — Thu, 13 Oct 2016 14:59:12 GMT

Inputfield should work for you. Or Input Variable.

Whichever you prefer

Re: Is it possible to set editable fields?

Anonymous — Thu, 13 Oct 2016 15:02:15 GMT

Mind, though, that using inputfield will not change the data in the database, should this be what you want to do.

Re: Is it possible to set editable fields?

Anonymous — Thu, 13 Oct 2016 15:15:37 GMT

Can I have an example on how to use it?

I have a field called problem description, I need that this field bring the data from database and I am being able to update the values. That I can change, it's not necessary to go to the database to save it, but if it's possible will be good too.

Re: Is it possible to set editable fields?

vishsaggi — Thu, 13 Oct 2016 15:39:56 GMT

Check here?

Inputfield example.qvw

Re: Is it possible to set editable fields?

Anonymous — Tue, 18 Oct 2016 15:40:41 GMT

Thank you for the example, but I need to set data. For example I have two columns, State and city

State City

Florida Miami

Florida doral

Those columns come from database, but in case that I need to update one of them to display, how can I use the example of the input field?

In this example I should be able to Update from doral to Doral.

Please let me know.

Re: Is it possible to set editable fields?

rupamjyotidas — Tue, 18 Oct 2016 15:57:14 GMT

In Script like this:

Inputfield City;

Load

State,

City

From your file;