Qlik Community

QlikView Documents

Documents for QlikView related information.

Free Text Box Extension Object

Employee
Employee

Free Text Box Extension Object

Version 1.0

This extension object produces a text box you can enter free text into. Text is linked to values in a key field. When the user makes a single selection in the key field in QlikView, any text linked to that key field will be displayed in the text box.The classic use case is to enable the user to record "Notes To The Accounts". These notes can be linked to specific divisions, and the relevant notes would be displayed when you select each division. A screen shot is provided below:

Screen_Shot.jpg

The extension object will submit the entered text (embedded in XML) to a URL for processing. The URL used is configurable, so you can develop your own web service to save the text to a database or other repository. However sample website code is provided with the extension object that stores the text in an XML document on the web server, and retrieves the text from that document when the user makes a selection in the key field. The sample website is written in Classic ASP and is provided as a “proof of concept” solution only.

FEATURES

  • Data is only retrieved when a single value is selected in the Key Field.
  • Data is only submitted for saving when the user clicks on the Save button.
  • The FreeTextBox will be disabled if the user has not selected a single value from the key field.
  • You can configure the extension object to NOT link data to a Key Field. Then the saved text will always be displayed, and the FreeTextBox will never be disabled.

Updates to the extension object will be placed on this same page in QlikCommunity. It has been tested with Chrome. Firefox and IE on the PC. It has been tested with Safari and Mercury browsers on iPad.

Note that this extension object is provided AS IS and is not supported in any way. But if you have any issues or suggestions then please post them here as comments and I will try to help out.

Attachments
Comments
Not applicable

Hi Lee,

I really like this and thank you for taking the time to share this with us. If I wanted to capture the employee details associated with a comment, how do i do this? In otherwords, an audit trail. Secondly would I be able to change a previous comment? Preferably, this should be a no and the user needs to be cognescent of any saves they make to the free form text. Thanks in advance for your feedback

Cheers,

Byron

Employee
Employee

Hi Byron

What you are after is a little different to the way the extension currently works. Currently the extension object only saves a single entry per key value, and it is always editable. For your needs you would create a new entry in the external file (or preferably DB) for each comment created, and stamp it with the datetime and employee name. Then you would retrieve the list of entries when the user selected a key value and display the list sequentially in a non-editable text box. I saw a nifty function here http://community.qlik.com/thread/5490?tstart=30 that could be used to collect the user input. This could then be submitted to the DB, and then the updated list returned to display. It wouldn’t be hard to modify the client side part, but you would need to develop a custom webservice to handle the submitted XML and do the DB queries.

Employee
Employee

Byron

And now that QlikView has announced Direct Discovery (http://www.qlik.com/us/company/press-room/press-releases/2012/en/1016-qlikview-direct-discovery-laun...) I can point out that it would be ideal for reteiving the list of notes fron your database as the user makes selections. So the only custom functionality you would need is the save of comments to the database.

Not applicable

you might want to use dynamic update instead of creating a webservice.

Employee
Employee

Thanks Matthias. Dynamic update will get the data into the QlikView application straight away, but it only places it into memory. So when the app is reloaded you lose that data if it hasn’t been saved somewhere that is available for reload.

Not applicable

...

Not applicable

Once the data is in the application via dynamic update, you could use partial reload to "STORE" as QVD or macro-export to xml. It's just to give some alternatives to using a webservice.

Employee
Employee

That’s a good idea – it would be good to remove the extra layer of coding involved in the web service. I haven’t tried calling a QV macro from within an extension object before though. I will find some time to test that and see how it goes. Thanks Matthias.

Not applicable

Hi Lee,

Thanks for the resource and I tried to install the free text box on my client by double click the .jar, but it is no success. Could you advise is it related to QV version and what should I do?

Thanks,

Employee
Employee

Hi Nick

Did you follow the instructions in the Read Me File to setup the website? What error are you getting?

Version history
Revision #:
1 of 1
Last update:
‎10-16-2012 09:33 PM
Updated by:
Employee