Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

adnan_rafiq
Not applicable

Dynamic update Help Urgent

Dear All

I have been looking into Dynamic update feature for Qlikview, that is very much advertised by QlikTeck but apparently

I am unable to find any decent place which explains limitations of dynamic update.

I would be appreciate if any one guide me about following.

1. How can update records from data source.

All the sample applications and help I have found is like this

Update TABLE SET Field1 = Value where Field2=  Value2

This Basically Set value of Field1 to 'Value' where Field2 = Value2,

But my Question is can i write where condition as 'Where Field2 >  Value2,

I tried to write like this but it didn't worked. Apparently it works only for '=' not less than or greater than

2. I am able to populate fixed value in Field1 but not able to pick updated value of  Field1 from data base.

can any one please guide me in this.

I would appreciate if any one answer my queries urgently

Regards

1 Reply
Not applicable

Re: Dynamic update Help Urgent

Adnan,

1. Dynamic data update only works on '=' condition. Unfortunately, other conditions such as <>, >,<, >=, <= do not work. I don't see a reason why QlikTech has not included these basic conditions.

2. Dynamic data works only on the In-Memory set of QlikView document. Any data out of the system memory has to be loaded by document reload.

Hope this helps