1 Reply Latest reply: Nov 8, 2012 5:34 AM by syed maqsood RSS

    Dynamic update Help Urgent

    Adnan Rafiq

      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

          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