topic Re: Qlikview dashboard reload time in QlikView

Qlikview dashboard reload time

pooja_prabhu_n — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have recently updated the qlikview dashboard to pull data from amazon web services. Earlier, dashboard was pointing to oracle database and it was taking hardly 4 mins to reload. Now, it is taking 1hr 40 mins to fetch same amount of record.

Any inputs on this would be very helpful.

Thanks,

Pooja

Re: Qlikview dashboard reload time

Anil_Babu_Samineni — Wed, 26 Jul 2017 06:04:54 GMT

AWS is bit vast load. try to store in QVD and load that QVD in Qlikview and reload then try

Re: Qlikview dashboard reload time

pooja_prabhu_n — Wed, 26 Jul 2017 06:13:08 GMT

Thanks for your response.

User wants the dashboard data to be refreshed for every 15 mins. So, is there any other way? other than storing data in the QVD.

Re: Qlikview dashboard reload time

Anil_Babu_Samineni — Wed, 26 Jul 2017 06:17:49 GMT

Even though, If you have QVD Store command in script. Data will do automatically update with in the Qlik. Aren't you?

I wonder, I don't think whether customer / USER expect this (I meant to say every 15 minutes data reload) and i don't recommend to this because recently i have face many issues with File sizes and data reload where we are generating Incremental Load.

Re: Qlikview dashboard reload time

pooja_prabhu_n — Wed, 26 Jul 2017 07:44:00 GMT

Than you. I will try to make use of QVD.

What might be the reason the dashboard is taking too much time to read data from AWS?

Please suggest if any qlikview connector is available to pull data from aws.

Re: Qlikview dashboard reload time

Anil_Babu_Samineni — Wed, 26 Jul 2017 07:51:03 GMT

I never tried AWS as my data source. But, For helping i got some related Diagram when i was with Amazon. May be this helps you to get in idea how data processing the word of algorithm