topic Re: Commenting with Dynamic Update in QlikView

Commenting with Dynamic Update

gshockxcc — Wed, 03 Jun 2015 22:21:19 GMT

Hi all,

I am very new to Qlikview, but I have had a LOT of help to run before I know how to walk, so to speak. I recently found this post which is exactly what I want to be able to add comments to a Qlikview app.

QlikView Commenting with Dynamic Update (no extension needed)

I am trying to implement this in my document. When I add a comment and click OK, the Edit Module window pops up, and I don't know why. I don't have any error messages that give me an indication of what's wrong.

Update: After commenting out pieces of the module, it appears that this is failing on in the "CreateComment" module.

SET Result = ActiveDocument.DynamicUpdateCommand ( SQL_String )

Thanks in advance.

Re: Commenting with Dynamic Update

Anonymous — Wed, 03 Jun 2015 23:20:51 GMT

Interesting thing...

I assume you didn't allow system access in the macro module.

Re: Commenting with Dynamic Update

ToniKautto — Wed, 03 Jun 2015 23:24:48 GMT

Do you have Dynamic Update enabled in your server license?

Check the LEF details in your QlikView Management Console.

Re: Commenting with Dynamic Update

gshockxcc — Wed, 03 Jun 2015 23:35:48 GMT

No, we don't. It appears that this would seem to be the cause of the problem!

I am following up with our Qlik representative. Thanks for saving me a lot of time debugging this.

Re: Commenting with Dynamic Update

gshockxcc — Wed, 03 Jun 2015 23:39:06 GMT

Yes, I checked to make sure that I did allow system access.

Re: Commenting with Dynamic Update

dgreenberg — Thu, 04 Jun 2015 13:14:39 GMT

Toni - could this Dynamic_Update;Yes be the key to my problem running dynamic update on the server?

I can only test in dev and this is what the license says:

Commenting with Dynamic Update

PRODUCTLEVEL;10;;2015-07-30

TIMELIMIT;VALUE;;2015-06-26

SPECIAL_EDITION;EVALUATION;;

SPECIAL_EDITION;TEST;;

NAMED_CAL_BY_MACHINE_ID;NO;;

TEST_EDITION;YES;;

NUMBER_OF_USERCALS;111;;

----

Would this prevent Dynamic Update from working on our Dev Server?

Thanks

Dan

Re: Commenting with Dynamic Update

gshockxcc — Thu, 04 Jun 2015 13:20:40 GMT

After some follow up, my issue was resolved by setting the document properties --> Server --> Dynamic Update (checkbox).

Once I changed this, things started working, and I was able to debug the comment box objects. I still have an issue with the tags, but I think that's my mistake, and not related to the macro.

Thanks