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:
[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.
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.