Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Can an extension object write back to QlikView?

I think the answer is no from what I've read but I just want to make sure.

I've successfully written an extension object that retrieves some data from the database, allows editing, and then writes that data back to the source database. From what I understand if I want that data then to be refreshed in QlikView it needs to be reloaded to from the database. In other words, there is no way for an extension object to write data back to QlikView is there?

8 Replies
mountaindude
Not applicable

Re: Can an extension object write back to QlikView?

I don't believe there is, no.

I went down the same route some half year ago, but came to the conclusion that it is not possible. Unfortunately.

Would love to hear about a solution if one exists though!

Not applicable

Re: Can an extension object write back to QlikView?

James,

as i know there are in general 3 ways to change data in your QV data model:

- reload

- dynamic update

- inputfields

You may set inputfields values via macro. Dynamic update is possible via macro or trigger.

Input fields can't change row numbers, only set values to defined (as input) fields.

Dynamic update may insert/update/delete rows. But it is not fast ....

I think, it should be possible to start macro or trigger actions from extension level.

regards

Darek

Not applicable

Re: Can an extension object write back to QlikView?

Thanks. Can anyone point me to an example of an extension object firing off a macro or a trigger? I am having trouble finding one online.

bmz
Not applicable

Re: Can an extension object write back to QlikView?

What I have seen is the following scenario with dynamic update:

  • Use an extension to write to a SQL database
  • Use a trigger on the SQL database to write the data into QlikView with the OCX
  • Dynamic update causes the app to display the new data

I've seen this work, BUT it was a PoC, and you're probably aware of all of the issues and limitations of dynamic update. 

simondachstr
Not applicable

Re: Can an extension object write back to QlikView?

Writing data back to QlikView is not possible unless you reload the document. Reason is, that during the loading process in QV the associated model is created which is then loaded into memory. The only ideal ways would be to use a dynamic update but this is verrry limited in terms of how many rows you can update at once and in frequency OR use Direct Discovery (I have little experience with this).

What you can also do is manually associate the data from SQL into QlikView through an extension object until the reload cycle has finished (By building dynamic queries depending on the selection). This can be very fast but it's not very efficient and definitely not what QV was designed for. This, however, can be a viable solution if you want to append simple metadata to a selection or row like a user comment etc.

rbecher
Not applicable

Re: Can an extension object write back to QlikView?

simondachstr
Not applicable

Re: Can an extension object write back to QlikView?

I've uploaded an open source version of a very identical Writeback extension:
http://community.qlik.com/docs/DOC-5970

Christof_Schwarz
Not applicable

Re: Can an extension object write back to QlikView?

Dynamic update does not work in a clustered server scenario. On a single server it can, however, the "to be" approach is to use Publisher to reload to deliver new data into the memory app. This could be a frequently triggered partial reload and this is also cluster-supported.

Another idea, if writing to SQL is already done, that table could also be integrated with Direct Discovery into the QlikView app ...