topic Is there a way to have an input field allow for multiple lines of text? in QlikView

Is there a way to have an input field allow for multiple lines of text?

Tue, 09 Jun 2009 06:45:39 GMT

I've got some text fields that I'm reading into variables in order to save to a file (through a macro), but one of the customer requirements is to have a multi line text box to type notes into, and I can't seem to find a way to do that within QlikView. Can this be done within QlikView?

[View:http://www.youtube.com/watch?v=3nwBMOTDgnc:425:340]

Is there a way to have an input field allow for multiple lines of text?

johnw — Wed, 10 Jun 2009 00:00:00 GMT

I don't know if it can be done. A while ago, I tried to figure it out, and was unable to. I'll be interested if anyone comes up with a way to do it.

Is there a way to have an input field allow for multiple lines of text?

Wed, 10 Jun 2009 00:28:26 GMT

Thanks John. I'm guessing if you worked on it for awhile, its not easy to do. The only thing I can come up with is a possible custom object, but I'm not familiar enough with the custom objects to do this myself yet.

Is there a way to have an input field allow for multiple lines of text?

Anonymous — Thu, 11 Jun 2009 09:10:30 GMT

I had something similar once... So, I used a button that opened the text file where user typed any text, and reloaded. Text from that file was used in a text box.
I know it's not the same, but it was acceptable in that situation.

Is there a way to have an input field allow for multiple lines of text?

Fri, 12 Jun 2009 05:40:15 GMT

Hey Michael,

Thanks for the idea; that's very creative. I like it. Did you launch a text editor for them to edit the file in?

Thanks!

Paul

Is there a way to have an input field allow for multiple lines of text?

Anonymous — Fri, 12 Jun 2009 07:27:55 GMT

Paul,
The button launched notepad, and opend the file. Actually this application had three or four launch buttons, each opened notepad with the different txt files - it's defined in the button properties. No need for macros. On reload, script reads the files into the fields or variables (don't remember exactly now), and the text box is just shows this field or variable. The major drawback is that the reload is required after editing.
I'm thinking about a different approach. Create an input box with X variables - v1, v2, ...vX - one per line of the text box. and the text box expression will be
=v1 & chr(10) & v2 & chr(10) & ... & chr(10) & vX.
No reload needed, but here the max number of lines is fixed. And probably less convinient for user, but this is a matter of preference...

Is there a way to have an input field allow for multiple lines of text?

Sat, 13 Jun 2009 00:21:20 GMT

Hey Michael,

I like the different approach. In your second approach, would the user have to hit return at the end of each line to get to the next line, or would the text word wrap?

Thanks!

Paul

Is there a way to have an input field allow for multiple lines of text?

Anonymous — Sat, 13 Jun 2009 01:28:11 GMT

Example atached.
You have to click into the next line in the input box. Or click anywhere outside when done. Yes, text will wrap in the text box if it's too long.

Is there a way to have an input field allow for multiple lines of text?

Anonymous — Sun, 14 Jun 2009 04:11:01 GMT

Paul,
It's a different question, may be you better start a separate thread about it. Probably what you need is the input field rather than a variable.

Is there a way to have an input field allow for multiple lines of text?

Mon, 15 Jun 2009 23:05:40 GMT

What about using the INPUTFIELD funtion eg
INPUTFIELD [Commentfield]; (put this at the start of your script)

Then above your actual data set in the script add a 'comment table':

TableComment:
LOAD
[CommentField];

Then load the rest of your data. If I created a straight table I was able to type in comments which would be saved and be able to view personally on reopening.

Hope this helps

Is there a way to have an input field allow for multiple lines of text?

Tue, 23 Jun 2009 05:38:59 GMT

Thanks Michael, this is great, not exactly what the client was thinking but good enough.

Is there a way to have an input field allow for multiple lines of text?

blaise — Tue, 23 Jun 2009 15:26:02 GMT

I would also go for the inputfield button. I've earlier created an "Notes" application, where users can add short notes about invoices. I used inputfield together with inputboxes and serversideexport. The user select an invoice (invoice No) and then press an Edit Notes button. A few inputboxes pops up there the user can add their notes (up to 254 chr long). I used the inputbox functionallity (rather then they inputfield) to get better control what the user types in. With this approach I also gained the possiblity to add timestamp and UserID (from the AD) to each invoice note.

I then put all theese into into a table box with inputfields, append the newly entered notes to a csv file. This way the user always sees his newly entered invoices (in the table box with the inputfields) and Im sure that I always store the notes inside the csv file and not in the *.qvw.shared file there the inputfield values are stored (on user level). Once a day I reload the application so all users can the the new notes.

I can tell you more about the solution if you want, I've came across a few issues on the way 🙂

Re: Is there a way to have an input field allow for multiple lines of text?

beckerv — Thu, 24 Jul 2014 12:09:25 GMT

Hi Johan,

I would be very interested in your solution regarding the usage of inputbox and inputfield.

I have created an application where it is necessary to enter comments.

The comments currently are entered via an inputbox and with a button (macro) then stored in an excel file.

However, I would also need the entered comments to be seen in the application immediately after saving it in the excel file WITHOUT reloading the script.

My goal is to enter the comments into the inputbox, press button to store it in excel file AND also storing the information within the inputfield (I assume that by doing so I can avoid reloading the script but still see the entered comments).

Would appreciate your help/experience in this case.

Thanks and best regards,

Viktoria