topic Re: Dashboard Performance Issue on Access Point in QlikView

Dashboard Performance Issue on Access Point

neha_shirsath — Fri, 21 Jul 2017 06:36:30 GMT

Hello Community,

Need your suggestion on best way to worked my access point dashboard.

I have QV server installed on Windows server 2012R2 with 512GB RAM & 64bit OS.

And my application size is 824MB but it's takes time to load data on access point it always buffer after every selection.

So, what should I do to increase my dashboard performance on access point.

I've done the all optimization techniques to reduce application size but it has heavy calculation of front end which i can't do in back end.

Help me for other solution.

Any help will be great appreciated.

Thanks in Advance.

Neha D.

Re: Dashboard Performance Issue on Access Point

arvind_patil — Fri, 21 Jul 2017 06:41:46 GMT

Hi Neha,

May be you need to update your QlikView version. I have faced the same issue on one of my client.

Thanks,

Arvind Patil

Re: Dashboard Performance Issue on Access Point

marcus_sommer — Fri, 21 Jul 2017 08:14:59 GMT

I think you will need to make the heavy calculations lighter by avoiding aggr-functions and nested if-constructs. Quite helpful could be to create flags within the script for the most heaviest calculations.

Another quite important point is the datamodel itself. If the gui is (too) slow you need to avoid link-table and/or snowflake models and going in the direction of a star-scheme or even a single table.

- Marcus

Re: Dashboard Performance Issue on Access Point

neha_shirsath — Fri, 21 Jul 2017 10:07:42 GMT

Yes I have used 2 link table but I cant avoid to used it because scenario like I have multiple dates coming from different table and calendar on multiple dates i.e i have created canonical calendar.

I tried with flag for heavy calculation but its not affect much in fact nothing.

Thanks for your help.

Re: Dashboard Performance Issue on Access Point

neha_shirsath — Fri, 21 Jul 2017 10:09:02 GMT

Thanks Arvind for your reply.

I'm not sure whether it will solve my issue or not that's why i'm holding this solution.