I have a Straight table and a Pivot table where I need the users to be able to add comments on a row item. I'm thinking I may not be able to do this for the Pivot table, but should be able to for the Straight table. The requirements are:
1. End user can enter a comment and it be saved for all users to view at the next scheduled reload
2. Free form text with the ability to add additional comments to the same field versus over-writing the existing comments - In other words, append additional comments to the same item (can live with over-writing if need be)
3. Need to be able to export the comments with the rest of the data - Annotations will thus not work
Here's what I've tried defining in the load script, but the Comments\Status field is not showing up at all:
[Comments-Table]: LOAD '' as[Comments\Status];
This field would then be added to a straight and pivot table of other data that's being loaded and specifically to data from an excel spreadsheet that does not have this field as a column. I'm sure I have a flaw in my logic, but hopefully you get the gist of what I'm trying to do, which is add a comments field end users can put their comments in and it be saved for all to see when the data is refreshed.
With that said, I've seen posts around macros, third party tools, etc., none of which though I have or can get. So I need this to be as native to Qlikview as possible. This, of course, may be Mission Impossible. 🙂 I am wide open to other ways to do this besides using an input field.
As always, thanks in advance for any and all help.
I'm using INPUTFIELD and not INPUTSUM. The expression for both the straight table and pivot table is Sum(Quantity). Quantity resides in an Excel spreadsheet. I intended for the Comments\Status field to be "empty" because it's a field where users need to input comments.
With the above said, I've seen threads where it says INPUTFIELD, essentially, needs to be numeric, but I've also seen threads where text is used.
Sure, Here my intention to ask question is INPUTFIELD is for script to justify in Metric like INPUTSUM. If your expression is used as Quantity then what does the use of INPUTFIELD in script. Would you able to provide sample to look and here, What are you achieving. is this related to you for Comments entered manually? like edit option in Straight table
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Unfortunately, I cannot share the data. I might be able to mock something up if we get to that point.
I'm not producing any metrics off of this field. It's simply intended to be a text field where end users can enter a comment and after a reload of the data, the comment or comments are still present. Nothing more. I probably should have been more specific in that regard. If INPUTFIELD is not the way to go, I'm open to other options, but again, I have no access to third party tools or Qlikview extensions, so the solution needs to be native to Qlikview.
Lastly, and I should have added this as well, it needs to work with Ajax client (server based).
I wish Qlik would make this a standard option as there appears to be plenty of demand for it.
P.S. Thank you for taking the time to respond Anil. I appreciate it.