topic INPUTFIELD Not Working As Expected in QlikView

INPUTFIELD Not Working As Expected

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

Hello:

I'm trying to set up an Inputfield for users to be able to add comments and / or status for a particular item in a straight table or pivot table. My initial focus has been on a straight table with the hope it can also work for a pivot table, i.e. update the straight table and it updates the same item / field in the pivot table. The objective is also for users to be able to see comments \ statuses input by other users, be able to export the dataset to include the comments \ statuses and the comments \ statuses be retained.

The Inputfield is an independent field I'm defining within the load script and is not a part of any other dataset I'm pulling in. I'm developing this using the desktop client for promotion to Qlikview server / Ajax client. Here's the latest way I've tried via the load script:

INPUTFIELD [Comments\Status];

[Comments\Status] = "Enter your Comments \ Status Here"

[Comments-Table]:
LOAD
[Comments\Status];

I have seen other posts regarding this, but I'm not understanding them. I believe I'm missing something basic. As always, any and all help will be appreciated.

As an aside, this seems to be a feature a lot of people would like to see added where it's more easily done. If anyone knows how I can make the enhancement request to Qlik for this, I'd be more than happy to do so.

Re: INPUTFIELD Not Working As Expected

swuehl — Sun, 11 Jun 2017 22:26:57 GMT

Not quite sure what your code should do, but you need a table source or at least an AUTOGENERATE for your table LOAD statement.

INPUTFIELD [Comments\Status];

[Comments-Table]:

LOAD

'Enter your Comments \ Status Here' as [Comments\Status]

AutoGenerate 1;

Besides that and AFAIR, the inputfield values are stored on a per user base, so this might not be the way to go for your final requirement.

There are some few discussions here in the forum that discuss how to enter and store comments (also have a look into the built-in server side collaboration feature), maybe using something like

Posting Data from QlikView to Other Systems using the Ajax Client

Re: INPUTFIELD Not Working As Expected

pnn44794 — Sun, 11 Jun 2017 22:58:41 GMT

Hello Stefan!

Thanks for your response. I know you're one of the top contributors to the community, so I greatly appreciate you taking the time to respond. I will check out the link you sent, probably tomorrow.

In the meantime since I posted my question, I've found a field within one of the datasets that I don't particularly care about, but which has a unique number for multiple rows. Meaning, I could have 4 rows with the same "Link" ID. I then have added a table box and made the Link field (renamed to Comments \ Status) an Input field. In both the client and Ajax, if I add a comment to that field, it updates all rows tied to it which is the desired effect.

To your point regarding different users being able to see the comments \ status entered, I won't know that until tomorrow, but you're probably right. They won't see them. That might be ok, at least initially.

Again, thank you very much for the response. It's appreciated.