Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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).
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
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 !!
Would you mind posting here a screenshot of your data model?
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
Hi,
please evaluate your data and the data model...
And read this...
https://community.qlikview.com/thread/120822
HTH
André Gomes
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