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.

leni_balakrishn
Not applicable

Using Macro to get newly added data from database

Hi,

Can anyone help me in retrieving the newly added/updated record in database to Qlikview application using a single button click with Macros.

Or is there any other way to do it.??

Thanks in advance.

Thanks,

Leni Balakrishnan

Tags (1)
6 Replies
jsn
Not applicable

Re: Using Macro to get newly added data from database

One way would be to use EDX. One example can be found here:

http://community.qlik.com/thread/47353

leni_balakrishn
Not applicable

Re: Using Macro to get newly added data from database

I need to get the changed/added data without reloading the qlikview application.

Thanks,

Leni Balakrishnan

jsn
Not applicable

Re: Using Macro to get newly added data from database

Well.. currently your only option is Dynamic Data Update which is pretty tricky and nothing I would recommend for this.

Once QV 11.2 is released you could look at using Direct Discovery to allow the app to query the source database table directly.

leni_balakrishn
Not applicable

Re: Using Macro to get newly added data from database

Can tel me how to use Dynamic Data Update to get the changed /added data from DB to Qlikview.??

Is there any document or sample available??

Thanks for your help.

jsn
Not applicable

Re: Using Macro to get newly added data from database

Hi,

No good examples available, maybe if searching the community a bit.

It'll be a third party program.. either using a macro or an external piece of code to push the data in the session. Also keep in mind that the data will only exist in the session, not inserted in the actual document until it is reloaded and the data loaded from source according to the load script.

leni_balakrishn
Not applicable

Re: Using Macro to get newly added data from database

Thanks Johannes...

I checked in community for an example but I didnt get a one which I need.

If you get any good document or example regarding this, kindly share it.