topic How to use Dynamic update action in QV 11 in QlikView

How to use Dynamic update action in QV 11

Wed, 11 Jan 2012 05:41:23 GMT

Hi,

Can any one tell me how to use the Dynamic update action in QV 11 .. Do We need to write macro to use this?

Re: How to use Dynamic update action in QV 11

Thu, 12 Jan 2012 12:23:39 GMT

Hello,

Yes, you need to write a macro. Look example in QlikView API guide - ActiveDocument.DynamicUpdateCommand.

How to use Dynamic update action in QV 11

Fri, 20 Jan 2012 17:00:16 GMT

I think you don't need to write macro anymore. Just create/add an action "Dynamic Update" and fill statement with something like this

UPDATE TestTable SET TestField = 'Test' WHERE TestField='abc';
UPDATE TestTable SET Discount = 123 WHERE TestField='Test';
UPDATE TestTable SET Discount = 123 WHERE UpdateTag=1;

How to use Dynamic update action in QV 11

Mon, 26 Mar 2012 06:09:31 GMT

Hi Dix

thanks

How to use Dynamic update action in QV 11

Tue, 27 Mar 2012 09:06:42 GMT

Hi Dix,

I am trying to figure out the following scenario in the context of Dynamic Update

Can it is possible,if i update the database then the changes should be reflected in my qlikview file.

The important point to consider is how qlikview associate the updated rocords with qvw with out reload

Please reply me back as u get it

How to use Dynamic update action in QV 11

Tue, 27 Mar 2012 09:30:10 GMT

Hi ghori.irf,

as far as I figured it out by now, dynamic update changes only the values in memory. As long as your application stays in memory, you should be fine. But you have to make sure, that your data is saved once in a while.

Currently I'm working on using an export action for that. The next reload has to check, if there are any previously exported files (xml, csv,...). You can try to combine this with an EDX-triggered reload.

Regards

Matthias

How to use Dynamic update action in QV 11

mdmukramali — Tue, 27 Mar 2012 12:02:58 GMT

Dear,

Matthias Dix.

I am too looking for the above same senario as ghori..

so please let me know step wise procedure to adop Dynamic Update ,If possible with an example.

I will be thankful from botom of my heart.

Thanks,
Mukram.

Re: How to use Dynamic update action in QV 11

Tue, 27 Mar 2012 14:38:34 GMT

Check my example

Re: How to use Dynamic update action in QV 11

mdmukramali — Wed, 28 Mar 2012 06:37:32 GMT

Dear,

Matthias DIx.

I am glad to have this stuff ,I refer this and get back to you if i come up with some doubt .

And I am thankful for your Hospitality .

Thanks,

Mukram,

Re: How to use Dynamic update action in QV 11

Wed, 28 Mar 2012 10:14:19 GMT

Hi Dix,

I try to implement dynamic update without macro,but its not working.

Please refer the attached file and help me out.

How to use Dynamic update action in QV 11

tanelry — Wed, 28 Mar 2012 12:20:20 GMT

qvd_irfan,

You need to check "Enable Dynamic Data Update" under Document Properties->Server tab.

Re: How to use Dynamic update action in QV 11

Wed, 28 Mar 2012 12:44:29 GMT

Thanks two of you

Tanel Ruutli and Matthias Dix.

Its working now

How to use Dynamic update action in QV 11

Anonymous — Mon, 28 May 2012 13:50:46 GMT

I've checked all the boxes and it's still isn't working for me. Not in the ajax client or with the IE plugin. If i open the document on the server (desktop version) everything works fine.

Any ideas? (i'm trying to get the example attaced earlier (from @matthias) to work

Tanks in advance!

How to use Dynamic update action in QV 11

Mon, 28 May 2012 14:04:51 GMT

Dynamic has to be activated on the server and in the document:

Which Version of IEPlugin and Server do you use? Are you using macro or button action? Can you provide any further details?

How to use Dynamic update action in QV 11

Anonymous — Mon, 28 May 2012 14:10:52 GMT

Thanks! Forgot the box on the server. I didn't get it to work for the plugin, just the Ajax, though but that's not necessary. Thank you again!

How to use Dynamic update action in QV 11

Mon, 28 May 2012 14:56:44 GMT

No problem 😉

How to use Dynamic update action in QV 11

Mon, 28 May 2012 16:02:54 GMT

Hello Matthias,

Everything seems to be ok on my server, but it does not work using the Ajax Client .

It work using the Local Client , Using Ajax on the server (Localhost) but does not work from external connection.

Any Idea ?

Thanks

Philippe

How to use Dynamic update action in QV 11

Mon, 28 May 2012 16:36:19 GMT

As far as I know, macro is not working in AJAX. But "dynamic update" as an action (i.e. on a button) should work in AJAX. I just tried it.

Have you checked the Server and Document properties (you have to activate Dynamic Update in both)?

If that doesn't work, please provide some further details...

How to use Dynamic update action in QV 11

Mon, 28 May 2012 16:47:11 GMT

The macro works using the Ajax client on a windows 7 server If I use a local user part of the Qlikview administrators group . It does not work on windows 2008 SR 2 server as I am not able to create local users with a different domain name .

Philippe

Re: How to use Dynamic update action in QV 11

sebastiandperei — Sat, 25 Aug 2012 15:19:24 GMT

Wow Dix... your sample is very great!!!

If I could, i put this discussion as Super Answered!!!