Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV Running Slow

Hi QV folks,

I developed a simple dashboard. The data structure is simple, an inpatient table and an emergency department table linked through a link table by account.

I created several charts for both inpatients and emergency department tabs/sheets; however, my emergency department sheet runs extremely slow. One of the issue that I found through google is that I used count(distinct) function because the emergency table has duplicate account to account for cycle time of each individual process step. I modified my data table to be able to use sum(). But QV still runs slowly.

I have developed 2 dashboards using QV before and have never seen such a issue. Does anyone have similar experience and would like to share your resolutions? Andif you have any references materials to optimize QV performance?

Thank you so much!

Regards,

Jihan

2 Replies
Clever_Anjos
Employee
Employee

Some tips:

1) Check if you have Synthetic Keys, they could (not always) make your performance poor.

2) At Sheet Properties / Objects tab check which object is the slowest

3) Try to isolate each expression of that object

Not applicable
Author

Thank you for the reply.