topic Re: Analysis in QlikView https://community.qlik.com/t5/QlikView/Analysis/m-p/272289#M101977 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Thanks for your response. i am having lot of objects .Let me check and update </SPAN></P></BODY></HTML> Thu, 01 Dec 2011 17:04:28 GMT brindlogcool 2011-12-01T17:04:28Z Analysis https://community.qlik.com/t5/QlikView/Analysis/m-p/272283#M101971 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Performance Issue:</SPAN></P><P><SPAN style="font-family: trebuchet ms,geneva;"><BR /></SPAN></P><P><SPAN style="font-family: trebuchet ms,geneva;"> How to analyse an performance issue in the mentioned scenario.Trying to access the QVW file in the desktop and the CPU usage and PF usage is less than 15%. But the qlikview objects are taking more than 10 min to calculate. Any suggestions i have checked the Application optimization techniques but still no use. Either in accesspoint or at the desktop it is taking too&nbsp; much time to calculate. <BR /></SPAN></P></BODY></HTML> Thu, 01 Dec 2011 14:52:41 GMT https://community.qlik.com/t5/QlikView/Analysis/m-p/272283#M101971 brindlogcool 2011-12-01T14:52:41Z Analysis https://community.qlik.com/t5/QlikView/Analysis/m-p/272284#M101972 <HTML><HEAD></HEAD><BODY><P>using nested variables? pivot tables that are fully expanded? too many dimensions? too many moving parts tothe expression? all those can contribute to it. </P><P></P><P>how many rows of data are you displaying? would be better to put a calculation condition to allow some selections to narrow the data down and then show results.</P></BODY></HTML> Thu, 01 Dec 2011 15:21:41 GMT https://community.qlik.com/t5/QlikView/Analysis/m-p/272284#M101972 avastani 2011-12-01T15:21:41Z Re: Analysis https://community.qlik.com/t5/QlikView/Analysis/m-p/272285#M101973 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Thanks for your response.</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">We have tried with restriction. But still the same problem. As the server resource is more than enough and CPU,PF usage is very low. </SPAN></P><P><SPAN style="font-family: trebuchet ms,geneva;">Yes we are using variables and labels. It is not pivot table but has multiple dimension and expression,also data size is huge.Is it going to impact the performance delay to 10 min. <BR /></SPAN></P><P></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">I didnt get what is meant by moving parts in expression? Let me know i will check for it in my application.<BR /></SPAN></P><P><SPAN style="font-family: trebuchet ms,geneva;"> <BR /></SPAN></P></BODY></HTML> Thu, 01 Dec 2011 16:00:03 GMT https://community.qlik.com/t5/QlikView/Analysis/m-p/272285#M101973 brindlogcool 2011-12-01T16:00:03Z Analysis https://community.qlik.com/t5/QlikView/Analysis/m-p/272286#M101974 <HTML><HEAD></HEAD><BODY><P>multiple dimensions is the problem along with multiple expressions... any calculated dimensions? they take up a lot of time.</P><P></P><P>post your chart only in a temp qvw here and i can check it</P></BODY></HTML> Thu, 01 Dec 2011 16:05:44 GMT https://community.qlik.com/t5/QlikView/Analysis/m-p/272286#M101974 avastani 2011-12-01T16:05:44Z Re: Analysis https://community.qlik.com/t5/QlikView/Analysis/m-p/272287#M101975 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">How to identiy which dimension/expression to take more time to calculate. Will the mem file help us or we need to do a manual evaluation</SPAN></P></BODY></HTML> Thu, 01 Dec 2011 16:11:13 GMT https://community.qlik.com/t5/QlikView/Analysis/m-p/272287#M101975 brindlogcool 2011-12-01T16:11:13Z Analysis https://community.qlik.com/t5/QlikView/Analysis/m-p/272288#M101976 <HTML><HEAD></HEAD><BODY><P>manual only. if there is calculated dimension try to remove it and put it in script.</P></BODY></HTML> Thu, 01 Dec 2011 16:26:12 GMT https://community.qlik.com/t5/QlikView/Analysis/m-p/272288#M101976 avastani 2011-12-01T16:26:12Z Re: Analysis https://community.qlik.com/t5/QlikView/Analysis/m-p/272289#M101977 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Thanks for your response. i am having lot of objects .Let me check and update </SPAN></P></BODY></HTML> Thu, 01 Dec 2011 17:04:28 GMT https://community.qlik.com/t5/QlikView/Analysis/m-p/272289#M101977 brindlogcool 2011-12-01T17:04:28Z