Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kkkumar82
Specialist III
Specialist III

Chart refreshing automatically

Hi all,

Today I have faced a different issue, the straight table which was working till yesterday , which was taking only 7 - 11 seconds for refreshing of data on some selections now taking 10 -15 minutes and the original issue is when I am navigating from any other sheet to

the sheet where I have built my chart, it is refreshing automatically even without any selections.

I have checked whether there are any triggers from sheet level or field level etc to validate my self.

I am using Qv 11 SR12. Does any of you faced this kind of issue.

7 Replies
Or
MVP
MVP

What you are describing doesn't sound like a problem. Your chart might have expressions or calculated dimensions that take a long time to parse, or it might be a table with so many cells that it takes a very long time for QlikView to build.

If you are unable to improve the performance of your chart by re-writing the problem expression/dimension, my recommended approach is to add a calculation condition to the chart in question, preventing it from calculating unless a reasonable selection has been made (e.g. count(distinct myField1) < 100).

marcus_sommer

Maybe your datamodel changed and is now missing some fields and/or associations and calculations are going now to a loosen table or something like this.

- Marcus

kkkumar82
Specialist III
Specialist III
Author

All,

This chart was working fine till yesterday, and today I added three mapping loads, so the problem started , I commented out the mapping loads, but couldn't figure out the accurate problem.

May be marcus I have to recheck the data model once again, but I sure I have not changed anything other than the mapping loads.

One thing really worrying me why the chart is refreshing when I am coming to the particular sheet with out any selections in that sheet or previous sheet.

Really helpless !!

Clever_Anjos
Employee
Employee

Would you mind posting here a screenshot of your data model?

marcus_sommer

A refreshing without any changes will be caused from a faulty or missing caching. If you haven't enough RAM (or there is a system-problem with them - have you done a restart from your environment?) or there other changes to them, maybe because it runs within a VM could have such effects.

Similar things might happen if you assigned variables or expressions through the script and there is something broken.

- Marcus

agomes1971
Specialist II
Specialist II

Hi,

please evaluate your data and the data model...

And read this...

https://community.qlikview.com/thread/120822

HTH

André Gomes

kkkumar82
Specialist III
Specialist III
Author

Hi Marcus,

I am using Desktop in RDP which is having nearly 800 GB RAM in my machine. I have to check for the restart.

Any how thanks for the suggestion