Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Master
Partner - Master

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
Author

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
Partner - Master
Partner - Master

Varun, Macro could be an option

example attach

Good luck

Fernando

Not applicable
Author

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
Partner - Master
Partner - Master

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
Author

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
Partner - Specialist II
Partner - Specialist II

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
Specialist
Specialist

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.

Bill_Britt
Former Employee
Former Employee

Hi,

Do you have the below in your LEF?

DYNAMIC_UPDATE;YES;;

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.