topic Re: Dashboard performance issue in QlikView

Dashboard performance issue

jelly_gvm — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

In my dashboard one of the report having 12 million records, how to improve the dashboard performance ? can any one help me.

Note :- For improving the performance, i have followed the below details

1. Removed unwanted tables and fields in the data model

2. Data model is STAR Schema

3. All calculations are done in the script not in reports.

4. My DEV server having 256 GB RAM and also 52% of RAM is free in the server, there no timeout problem.

Thanks in Advance

Regards,

Ram M

Re: Dashboard performance issue

daniel_kusiak — Wed, 29 Jul 2015 06:20:45 GMT

Hi jelly_gvm

Try to use this tool - QV Document Analyzer. You can download it here: http://qlikviewcookbook.com/tools/

Maybe it will give you some insight.

Re: Dashboard performance issue

jelly_gvm — Wed, 29 Jul 2015 06:29:06 GMT

Thanks for your kind reply, i have used the QV Document Analyzer, but still i'm having some performance issues.

Can you suggest me any other technique ?

Regards,

Ram M

Re: Dashboard performance issue

Wed, 29 Jul 2015 06:37:30 GMT

Hi Ram

I had encountered the similar problem where the data on the dashboard was delayed. I realized that the amount of the data that was showing on the dashboard was not the usually required 99 % of time. I applied some default bookmarks on opening of the sheet and applied conditional statement on the chart which improved the user experience.

It could be something you could consider for better UI experience.

Thanks

Re: Dashboard performance issue

sunilkumarqv — Wed, 29 Jul 2015 06:41:19 GMT

the only other technique is document chaining .

break the data into diff parts and create the chain

Re: Dashboard performance issue

robert_mika — Wed, 29 Jul 2015 06:43:54 GMT

Are your tables saved in QVD's?

Re: Dashboard performance issue

jelly_gvm — Wed, 29 Jul 2015 07:45:08 GMT

yes all the tables are saved in QVD's.