topic Re: QlikView Commenting with Dynamic Update (no extension needed) in QlikView

QlikView Commenting with Dynamic Update (no extension needed)

Mon, 13 Jan 2014 15:13:02 GMT

I created an example for commenting in QlikView. It uses Dynamic Update and Macro. I successfully tested it in QlikView Client AND on QlikView Server.

Downside:

not supported in AJAX (b/c macro is used)
users might have to be in QlikView Administrator Group to use Dynamic Update

I also came up with an example using InputFields, but that is not as good as this one.

Feel free to post improvement ideas.

Re: QlikView Commenting with Dynamic Update (no extension needed)

Mon, 26 May 2014 10:16:02 GMT

Hi Matthias,

I am very impressed by your idea, which seems very easy to implement and is the solution to something lots of clients demand !

Thank you for sharing.

Re: QlikView Commenting with Dynamic Update (no extension needed)

Mon, 10 Nov 2014 11:19:19 GMT

Hi Matthias,

This works on desktop client but macro parse fails and functionality is lost in access point..

Please Help

Thanks,

Pratik

Re: QlikView Commenting with Dynamic Update (no extension needed)

agomes1971 — Mon, 10 Nov 2014 11:30:50 GMT

Hi,

please lookup at this nice solution:

SQL Writeback from QlikView extension object.

Hope it helps

André Gomes

Re: QlikView Commenting with Dynamic Update (no extension needed)

simondachstr — Mon, 10 Nov 2014 11:37:43 GMT

+ Dynamic Update entries will be lost once the document is refreshed/reloaded. Another downside is that dynamic updates entries are not shared in a clustered environment (As each cluster has its own in memory data cloud).

Re: QlikView Commenting with Dynamic Update (no extension needed)

Mon, 10 Nov 2014 11:39:02 GMT

Thanks for the reply but I started with the same solution, went on to dynamic upadte,Direct Query and now seraching extensions which woud provide the same functionality. As the macros run on cliet well but does nt run on access point. Macro Parse Failed.

Regards,

Partik

Re: QlikView Commenting with Dynamic Update (no extension needed)

Mon, 10 Nov 2014 14:40:27 GMT

I had "Macro Parse Failed" error, when having tiny errors in my macro code. You might check your code once again or provide it here and we could have a look together.

Re: QlikView Commenting with Dynamic Update (no extension needed)

Tue, 11 Nov 2014 07:08:56 GMT

Hi Matthias,

I downloaded the example which u posted, it runs perfectly on desktop but fails in access point.

Did it work for You on access point?

Client Details( version-11.20 SR-8 64 bit Edition)

Server Details ( version- 11.20 SR-4 64-bit )

Is it because of SR-4 and SR-8 incompatibility?

Thanks,

Pratik

Re: QlikView Commenting with Dynamic Update (no extension needed)

Tue, 11 Nov 2014 07:11:04 GMT

Also can u provide your client and server details?

Re: QlikView Commenting with Dynamic Update (no extension needed)

Tue, 11 Nov 2014 14:21:19 GMT

It fails in Access Point

either because of AJAX (no macro support) or
you are not in the QlikView Administrators group (needed for dynamic update) or
your security settings on the server or
you forgot to activate dynamic update on the server

Re: QlikView Commenting with Dynamic Update (no extension needed)

qliknerd — Fri, 06 Feb 2015 17:32:07 GMT

Nice work Matthias, I have been asked for a while how to get this implemented on our site! It took me a while to figure out that I needed to check the option "Enable Dynamic Update" under server settings in doc properties, but once done I was able to build a test application.

Have you experienced any issues with multiple users trying to update at the same time?

Regards

Ian

Re: QlikView Commenting with Dynamic Update (no extension needed)

gshockxcc — Wed, 03 Jun 2015 20:40:40 GMT

Matthias,

I love it. Thanks for your post. This is enormously helpful. Thanks so much.

Re: QlikView Commenting with Dynamic Update (no extension needed)

Anonymous — Mon, 19 Oct 2015 16:49:05 GMT

Hello Matthias

This is a great example of a much needed feature. I would like to use in my app but I know very little about macros/VBscript. Any chance you could provide a technical brief on your macro for those who dont know much on how to implement one? Would be much appreciated.

Re: QlikView Commenting with Dynamic Update (no extension needed)

Anonymous — Wed, 27 Jul 2016 18:26:59 GMT

Hello Matthias,

Thank you for putting this out there. I have tested your file and it works locally but when I run on the server with Publisher I get no popup to enter in a value. I have tested in both IE with the IE Plungin and Chrome.

I have given system access to the macros in the application and set the proper server macro setting.

We are running server 11.2.

Thank you.

Re: QlikView Commenting with Dynamic Update (no extension needed)

Wed, 27 Jul 2016 19:42:40 GMT

hi darrin, see my post and screenshots in this thread https://community.qlik.com/thread/45050

make sure that dynamic update is activated on the server! Hope this helps. Kind regards Matthias

Re: QlikView Commenting with Dynamic Update (no extension needed)

Wed, 27 Jul 2016 19:45:05 GMT

oh. By the way, macros won't work on ajax, if you're trying this...

Downside:

not supported in AJAX (b/c macro is used)

users might have to be in QlikView Administrator Group to use Dynamic Update

Re: QlikView Commenting with Dynamic Update (no extension needed)

Anonymous — Wed, 27 Jul 2016 19:51:02 GMT

Ah well that kills this whole process then as we need to do exactly what this does from AccessPoint.

I thought I read that macros are possible from the server.

Thank you for getting back to me.