topic Using Macro to get newly added data from database in QlikView https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443620#M701093 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone help me in retrieving the newly added/updated record in database to Qlikview application using a single button click with Macros.</P><P></P><P>Or is there any other way to do it.??</P><P></P><P>Thanks in advance. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks,</P><P>Leni Balakrishnan</P></BODY></HTML> Mon, 19 Nov 2012 05:42:14 GMT Anonymous 2012-11-19T05:42:14Z Using Macro to get newly added data from database https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443620#M701093 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone help me in retrieving the newly added/updated record in database to Qlikview application using a single button click with Macros.</P><P></P><P>Or is there any other way to do it.??</P><P></P><P>Thanks in advance. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks,</P><P>Leni Balakrishnan</P></BODY></HTML> Mon, 19 Nov 2012 05:42:14 GMT https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443620#M701093 Anonymous 2012-11-19T05:42:14Z Re: Using Macro to get newly added data from database https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443621#M701094 <HTML><HEAD></HEAD><BODY><P>One way would be to use EDX. One example can be found here:</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/47353" title="http://community.qlik.com/thread/47353">http://community.qlik.com/thread/47353</A></P></BODY></HTML> Mon, 19 Nov 2012 06:01:28 GMT https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443621#M701094 Anonymous 2012-11-19T06:01:28Z Re: Using Macro to get newly added data from database https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443622#M701095 <HTML><HEAD></HEAD><BODY><P>I need to get the changed/added data without reloading the qlikview application.</P><P></P><P>Thanks,</P><P>Leni Balakrishnan</P></BODY></HTML> Mon, 19 Nov 2012 06:10:08 GMT https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443622#M701095 Anonymous 2012-11-19T06:10:08Z Re: Using Macro to get newly added data from database https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443623#M701096 <HTML><HEAD></HEAD><BODY><P>Well.. currently your only option is Dynamic Data Update which is pretty tricky and nothing I would recommend for this.</P><P>Once QV 11.2 is released you could look at using Direct Discovery to allow the app to query the source database table directly.</P></BODY></HTML> Mon, 19 Nov 2012 06:17:07 GMT https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443623#M701096 Anonymous 2012-11-19T06:17:07Z Re: Using Macro to get newly added data from database https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443624#M701097 <HTML><HEAD></HEAD><BODY><P>Can tel me how to use Dynamic Data Update to get the changed /added data from DB to Qlikview.??</P><P></P><P>Is there any document or sample available??</P><P></P><P>Thanks for your help.</P></BODY></HTML> Mon, 19 Nov 2012 06:22:45 GMT https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443624#M701097 Anonymous 2012-11-19T06:22:45Z Re: Using Macro to get newly added data from database https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443625#M701098 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>No good examples available, maybe if searching the community a bit.</P><P>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.</P></BODY></HTML> Mon, 19 Nov 2012 06:31:31 GMT https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443625#M701098 Anonymous 2012-11-19T06:31:31Z Re: Using Macro to get newly added data from database https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443626#M701099 <HTML><HEAD></HEAD><BODY><P>Thanks Johannes...</P><P></P><P>I checked in community for an example but I didnt get a one which I need.</P><P></P><P>If you get any good document or example regarding this, kindly share it.</P></BODY></HTML> Mon, 19 Nov 2012 06:53:30 GMT https://community.qlik.com/t5/QlikView/Using-Macro-to-get-newly-added-data-from-database/m-p/443626#M701099 Anonymous 2012-11-19T06:53:30Z