Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

Inputfield Help - Right Thing To Use?

Hello:

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:

INPUTFIELD [Comments\Status];

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

6 Replies

Re: Inputfield Help - Right Thing To Use?

How you are giving in measure for Straight table? Can you share application, Please?

Always '' will return null. So, When you use InputSum(FieldName) it returns null only.

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)
Partner
Partner

Re: Inputfield Help - Right Thing To Use?

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.

Re: Inputfield Help - Right Thing To Use?

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)
Partner
Partner

Re: Inputfield Help - Right Thing To Use?

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.

Re: Inputfield Help - Right Thing To Use?

May be marcus_sommer‌ helps you few insights related to the concern

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)
Partner
Partner

Re: Inputfield Help - Right Thing To Use?

Ok.  It looks like Marcus is an awesome resource, but I'm not familiar with navigating the link.  Where would I go for this particular issue?  And thanks for the pointer!