topic Re: Data Reloading in QlikView

Data Reloading

agni_gold — Thu, 26 Dec 2013 09:13:05 GMT

I have some doubts regarding qlikview Application:

If i have a QVW file with data loading and some more functionality . I want , if any data changes in the source table or file then , can it reload automatically? if yes then how it is possible?

Something like trigger.

Re: Data Reloading

Anonymous — Thu, 26 Dec 2013 09:18:15 GMT

You can only schedule the reload processes for varying time, but

it cannot reload automatically whenever there is change in Datasource, this would be a real time system and it would create a great impact on performance of live system(transactional system).

Resolution, why not you reaload your application on hourly of half hourly basis.??

Regards

Nitin

Re: Data Reloading

israrkhan — Thu, 26 Dec 2013 09:18:58 GMT

Hi,

its not possible to load data when source data get changed, but you can schedule data reloading on time base, like every data, every hour. and so on.

Secondly, you said change in database fields, but they changed the fields name, then use the * keyword, instead of mentioning field name in the load script.

Re: Data Reloading

Thu, 26 Dec 2013 09:19:20 GMT

In QlikView Server there is a component called Publisher. This component exposes an API called EDX which you can use from external processes to launch Publisher tasks like reloading a document. You could use a trigger in your data source system to launch a QlikView reload task.

More information about EDX here (http://community.qlik.com/docs/DOC-2650) or in the SDK (http://community.qlik.com/docs/DOC-2639).

Re: Data Reloading

suresh_rawat — Thu, 26 Dec 2013 09:26:07 GMT

Hi Agnivesh,

In QlikView you can only schedule your reload in QlikView Access Point.

And that depends how quickly your data updating in your system.

You can schedule your reload accordingly - for half-hourly, hourly, daily, monthly.....

Regards

Suresh Rawat

Re: Data Reloading

Thu, 26 Dec 2013 09:26:17 GMT

Hi,

As suggested by everyone, you can schedule the file.

I had a similar scenario with a slight variation. I had a field called "load_progress" whose value if greater than 20 then it would mean that the data in the source tables have refreshed and have changes, so I scheduled the file reload on this condition.

So, if you have a field whose values can indicate whether the source tables have reloaded or not, then you can schedule the reload of the file based on the value of that field.

Hope this helps!

Re: Data Reloading

agni_gold — Thu, 26 Dec 2013 09:30:05 GMT

Thanks Israr,

So can we schedule this loading on client side ? if yes then how ?

Re: Data Reloading

brijesh1991 — Thu, 26 Dec 2013 09:30:53 GMT

EDX trigger is working fine in my case.

You can use it without hesitation, but make sure it won't affect your performance i.e how frequently data is changing

Re: Data Reloading

agni_gold — Thu, 26 Dec 2013 09:32:31 GMT

So can we schedule this loading on client side ? if yes then how ?