Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW

Free Text Box Extension Object

lms
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

0 Likes
lms
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.

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

0 Likes
Not applicable

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

0 Likes
lms
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.

0 Likes
Not applicable

...

0 Likes
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.

0 Likes
lms
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.

0 Likes
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,

0 Likes
lms
Employee
Employee

Hi Nick

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

0 Likes
Version history
Last update:
‎2012-10-16 09:33 PM
Updated by:
Employee