Dynamic update Help Urgent

adnan_rafiq — Tue, 18 Sep 2012 18:48:48 GMT

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

Re: Dynamic update Help Urgent

Thu, 08 Nov 2012 10:34:43 GMT

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

topic Dynamic update Help Urgent in QlikView

Dynamic update Help Urgent

Re: Dynamic update Help Urgent