topic Re: Chart refreshing automatically in QlikView https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166075#M379596 <HTML><HEAD></HEAD><BODY><P>Hi Marcus,</P><P>I am using Desktop in RDP which is having nearly 800 GB RAM in my machine. I have to check for the restart.</P><P></P><P>Any how thanks for the suggestion</P></BODY></HTML> Wed, 24 Aug 2016 14:28:09 GMT kkkumar82 2016-08-24T14:28:09Z Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166068#M379589 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>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 </P><P>the sheet where I have built my chart, it is refreshing automatically even without any selections. </P><P></P><P>I have checked whether there are any triggers from sheet level or field level etc to validate my self.</P><P></P><P>I am using Qv 11 SR12. Does any of you faced this kind of issue.</P></BODY></HTML> Wed, 24 Aug 2016 13:30:17 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166068#M379589 kkkumar82 2016-08-24T13:30:17Z Re: Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166069#M379590 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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) &lt; 100).</P></BODY></HTML> Wed, 24 Aug 2016 13:34:45 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166069#M379590 Or 2016-08-24T13:34:45Z Re: Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166070#M379591 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 24 Aug 2016 13:35:06 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166070#M379591 marcus_sommer 2016-08-24T13:35:06Z Re: Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166071#M379592 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>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. </P><P></P><P>Really helpless !!</P></BODY></HTML> Wed, 24 Aug 2016 13:40:55 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166071#M379592 kkkumar82 2016-08-24T13:40:55Z Re: Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166072#M379593 <HTML><HEAD></HEAD><BODY><P>Would you mind posting here a screenshot of your data model?</P></BODY></HTML> Wed, 24 Aug 2016 13:43:24 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166072#M379593 Clever_Anjos 2016-08-24T13:43:24Z Re: Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166073#M379594 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Similar things might happen if you assigned variables or expressions through the script and there is something broken.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 24 Aug 2016 13:50:22 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166073#M379594 marcus_sommer 2016-08-24T13:50:22Z Re: Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166074#M379595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please evaluate your data and the data model...</P><P></P><P>And read this...</P><P></P><P><A href="https://community.qlikview.com/thread/120822" style="font-size: 10pt; line-height: 1.5em;" title="https://community.qlikview.com/thread/120822">https://community.qlikview.com/thread/120822</A></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Wed, 24 Aug 2016 13:55:21 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166074#M379595 agomes1971 2016-08-24T13:55:21Z Re: Chart refreshing automatically https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166075#M379596 <HTML><HEAD></HEAD><BODY><P>Hi Marcus,</P><P>I am using Desktop in RDP which is having nearly 800 GB RAM in my machine. I have to check for the restart.</P><P></P><P>Any how thanks for the suggestion</P></BODY></HTML> Wed, 24 Aug 2016 14:28:09 GMT https://community.qlik.com/t5/QlikView/Chart-refreshing-automatically/m-p/1166075#M379596 kkkumar82 2016-08-24T14:28:09Z