topic Dynamic Updates on Server in QlikView

Dynamic Updates on Server

Mon, 26 Jan 2026 18:19:17 GMT

Hi All, I have a file with text boxes having Dynamic Update action which works great on my system. But the updates stop happening after deploying it on the server. I have checked all the options for allowing dynamic update inside the file, as well as the options in server QV Management Console. Does anyone have a clue why this may be happening. Do I require a special license for allowing updates on the server. I'm using QV version 11.20

Thanks !

Re: Dynamic Updates on Server

fkeuroglian — Thu, 22 May 2014 22:10:03 GMT

Hi, are you using macro?

what browser are you using?

check all the image attached and sure that the propertys are ok

Good luck

Fernando

Re: Dynamic Updates on Server

Thu, 22 May 2014 22:28:09 GMT

Thanks for replying Fernando. I am using Internet Explorer and all the properties in the images are enabled. I'm not using a macro, I have a text box with the update statement written in the 'Dynamic Update' action of the text box. It works in the desktop mode and Web view, but not on the server.

Re: Re: Dynamic Updates on Server

fkeuroglian — Thu, 22 May 2014 22:39:58 GMT

Varun, Macro could be an option

example attach

Good luck

Fernando

Re: Dynamic Updates on Server

Fri, 23 May 2014 00:20:44 GMT

Hi Fernando, I realized that my Dynamic update statement has the '>=' condition which does not work on the server.

My statement is:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date >= '$(vUserDate)';

= condition works on the server, but <= or >= don't work. I need to use >= , do you know any way to get it working, probably by changing the statement syntax.

Thanks

Re: Dynamic Updates on Server

fkeuroglian — Fri, 23 May 2014 00:26:33 GMT

Hi, try to separate?

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDate)' or Limit_Date = '$(vUserDate)' ;

separate >= in > or =

would be an option

Re: Dynamic Updates on Server

Fri, 23 May 2014 01:01:56 GMT

Hi Fernando, Thanks for the suggestion, but even the separate symbols do not work. I also read here (BI Review: Using Dynamic Updates in QlikView 11) that only the = condition works in dynamic updates. I tested my file with > which updated data in the desktop QV but not on the server.

Re: Dynamic Updates on Server

jerrysvensson — Mon, 26 May 2014 12:09:46 GMT

Why not create vUserDateMinusOne = vUserDate -1 day?

Then:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDateMinusOne)';

BTW, have you verified with a basic test that your Dynamic update actually works on server?

The user has be part of the QlikView administrator group.

Re: Dynamic Updates on Server

maleksafa — Mon, 26 May 2014 12:21:11 GMT

hi,

the dynamic update requires a high level of permissions for the users to execute it from the web (access point), the user must be in the 'QlikView Administrator' group.

Re: Dynamic Updates on Server

Bill_Britt — Tue, 27 May 2014 15:11:52 GMT

Hi,

Do you have the below in your LEF?

DYNAMIC_UPDATE;YES;;

Bill

Re: Dynamic Updates on Server

Tue, 27 May 2014 23:27:25 GMT

Hi Jerry, I have verified with a test that dynamic update is working on the server when I use the equality '=' condition. But it doesn't work when I use >,<,>= or <=.

The user is a part of the administrative group. The update you suggested with vUserDateMinusOne still has the > symbol so it will not work for me.

Thanks for the suggestions though.

Re: Dynamic Updates on Server

Tue, 27 May 2014 23:28:48 GMT

Hi Malek. In this case the user is in the administrators group. The dynamic update is working on the server with equality '=' condition only and not with <,<=,> or >=

Thanks

Re: Dynamic Updates on Server

Tue, 27 May 2014 23:32:51 GMT

Hi Bill, I do not have this line in my license. I guess it could be an issue but I'm still able to do dynamic updates on server when I use just the = condition

This line works on server:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date = '$(vUserDate)';

This doesn't work:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDate)';

I'm guessing that if I was restricted by license then the first line may not have worked either.

Thanks,

Varun

Re: Dynamic Updates on Server

maleksafa — Wed, 28 May 2014 10:50:36 GMT

Hi,

there is nothing special in the license that you should have, only the user security permissions must be applied, i have already faced the same issue where it worked on the server but not from the access point, and i did open a CRM ticket with qliktech and they have only requested to add the user that is using the dynamic update to the qlikview administrator group.