topic Re: Refresh the data any time in QlikView

Refresh the data any time

arulsettu — Tue, 26 May 2015 11:20:29 GMT

Hi,

i used developed app like

Extractor

data model

application

now user asking to keep a button to reload the new data at anytime. i set the task at QMC etractor is sucessfull data model will run datamodel is sucessfull application will run. task is running everyday 4 A.M. but user ask to reload at any time they visit. is this possible.

please guide me the way to do it.

Thanks

Re: Refresh the data any time

Anonymous — Tue, 26 May 2015 11:22:36 GMT

Not recommended but possible, see this document:

Using EDX in QlikView 11

Re: Refresh the data any time

arulsettu — Tue, 26 May 2015 11:27:38 GMT

incremental load will not work here right?

Re: Refresh the data any time

ToniKautto — Tue, 26 May 2015 11:34:27 GMT

Incremental load means that you only load the delta from your previous load and thereby probably get a more efficient load cycle. It can be part of allowing more frequent reloads.

User-driven reload will easily overload your server. Just consider what will happen if multiple user start a reload at the same time or while a previous reload is being executed. You will be better of with planning tighter reloads on the server side.

Re: Refresh the data any time

arulsettu — Tue, 26 May 2015 11:34:29 GMT

any other alternate way or sugtgestions for this?

Thanks

Re: Refresh the data any time

arulsettu — Tue, 26 May 2015 11:37:13 GMT

Thanks for the suggestion Toni

Re: Refresh the data any time

timanshu — Tue, 26 May 2015 11:57:03 GMT

Incremental load can decrease the document loading time. But it can't make data to be updated at anytime required.

Re: Refresh the data any time

Anonymous — Tue, 26 May 2015 11:58:56 GMT

Think of a continuous reload. The new reload starts as soon as the previous one ends.

Re: Refresh the data any time

arulsettu — Tue, 26 May 2015 12:10:32 GMT

i think i have done like this

i set the task at QMC extractor is sucessfull data model will run datamodel is sucessfull application will run.

is this right?

but user cant reload like this right?

Thanks

Re: Refresh the data any time

timanshu — Tue, 26 May 2015 12:15:10 GMT

There is a way but then user will be able to see another document opening and reloading.

If that is not an issue then when user opens application then extractor will open and reload. then modelling and then main application will load.

Re: Refresh the data any time

Anonymous — Tue, 26 May 2015 12:15:19 GMT

Correct. User can't reload this way, it is just a way to get the freshest possible data without user intervention. For user initiated reload, the EDX is the only way.

Again, I wouldn't recommend it, especially if you use the continuous reload already. You can end up with multiple reloads of the same app at the same time.

Re: Refresh the data any time

ajaykumar1 — Tue, 26 May 2015 12:22:03 GMT

Hi Arul,

Your Requirement seems that whenever the user clicks on the button the application should refresh...correct.

Task1: Extractor---->Data Model --> Applcation

Then create one dummy task which should complete in short time like in 1 min.

Then in trigeers----->Schedule the Task1 after completion of Dummy task.

It indicates that your application will run always.

But its not recommended....If your can't agree.We are helpless.

Thanks,

Ajay

Re: Refresh the data any time

arulsettu — Tue, 26 May 2015 12:26:20 GMT

when clikcking new data only reloaded so the reload time will be short. this is user asking

Re: Refresh the data any time

timanshu — Tue, 26 May 2015 12:49:41 GMT

Then implement incremental load.

Re: Refresh the data any time

Anonymous — Tue, 26 May 2015 13:29:08 GMT

What about Direct Discovery?

Re: Refresh the data any time

Anonymous — Tue, 26 May 2015 13:33:41 GMT

QlikView is a great tool for BI, Data Discovery / Analysis and I love it and use it to great affect.

But I suspect your user is after an operational report / screen of information. If this is the case then QlikView may well not be the correct tool to use.

Re: Refresh the data any time

Anonymous — Tue, 26 May 2015 13:46:45 GMT

1. Giving control to user is not good practice and even QlikView recommend this.

2. You can have a incremental load (if it is possible in your scenario) and schedule your app load in server side increase frequency of load (may be 15 min or 5 min) depending on your need.

Also consider when reload finished. every time user's selection is clear in qlikview.

So if you make it very frequent . your user will be not able to do analysis or it will be frustrating task.

Thanks

BKC

Re: Refresh the data any time

Tue, 26 May 2015 13:50:59 GMT

I would challenge your users, it isn't really a good idea to allow them to refresh whenever they wish.