Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Dynamic Updates on Server

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 !

Labels (1)
13 Replies
fkeuroglian
Honored Contributor

Re: Dynamic Updates on Server

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

Not applicable

Re: Dynamic Updates on Server

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.

fkeuroglian
Honored Contributor

Re: Re: Dynamic Updates on Server

Varun, Macro could be an option

example attach

Good luck

Fernando

Not applicable

Re: Dynamic Updates on Server

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

fkeuroglian
Honored Contributor

Re: Dynamic Updates on Server

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

Not applicable

Re: Dynamic Updates on Server

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.

jerrysvensson
Valued Contributor II

Re: Dynamic Updates on Server

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.

maleksafa
Valued Contributor

Re: Dynamic Updates on Server

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.

Employee
Employee

Re: Dynamic Updates on Server

Hi,

Do you have the below in your LEF?

DYNAMIC_UPDATE;YES;;

Bill