topic Re: Problem loading Stacked Chart in QlikView https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139501#M373641 <HTML><HEAD></HEAD><BODY><P>Hi, Thank You for sharing the link. It improved performance lot. But am facing issue with label.</P><P></P><P>I am using drill down group in derived expression. So can you please help me to set the label for the dimension.</P></BODY></HTML> Wed, 25 May 2016 11:48:30 GMT 2016-05-25T11:48:30Z Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139499#M373639 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We are using stacked chart with dynamic dimensions with simple expressions sum(spend) and relative spend showing top 10. It is working fine so far with less amount of data. But now data is increased, one dimension has 190K rows and the fact table has 3.5M rows. we are using star schema.</P><P><IMG __jive_id="124491" alt="Example.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/124491_Example.png" style="height: 260px; width: 620px;" /></P><P>With this amount of data chart is not loading in UI and Access Point.</P><P></P><P>can someone give suggestions to fix this problem?</P><P></P><P>Thanks for your support.</P><P></P><P>Regards,</P><P>Sai Krishna.</P></BODY></HTML> Fri, 13 May 2016 08:10:03 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139499#M373639 2016-05-13T08:10:03Z Re: Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139500#M373640 <HTML><HEAD></HEAD><BODY><P>Which method to show Top10 are you using?</P><P></P><P>Have you tried limiting your data using set analysis?</P><P></P><P><A href="http://www.naturalsynergies.com/q-tip-5-show-top-performers-common-but-not-too-trivial/" title="http://www.naturalsynergies.com/q-tip-5-show-top-performers-common-but-not-too-trivial/">QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies</A></P></BODY></HTML> Fri, 13 May 2016 16:08:22 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139500#M373640 swuehl 2016-05-13T16:08:22Z Re: Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139501#M373641 <HTML><HEAD></HEAD><BODY><P>Hi, Thank You for sharing the link. It improved performance lot. But am facing issue with label.</P><P></P><P>I am using drill down group in derived expression. So can you please help me to set the label for the dimension.</P></BODY></HTML> Wed, 25 May 2016 11:48:30 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139501#M373641 2016-05-25T11:48:30Z Re: Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139502#M373642 <HTML><HEAD></HEAD><BODY><P>Could you elaborate more what the issue with the label is?</P></BODY></HTML> Wed, 25 May 2016 15:19:26 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139502#M373642 swuehl 2016-05-25T15:19:26Z Re: Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139503#M373643 <HTML><HEAD></HEAD><BODY><P>I have a drilldown group "PProduct Group" with SKU and Product.</P><P></P><P>When I use [PProduct Group] as dimension, label is displayed properly, SKU and Product based on selection. But when I use calculated dimension like "=AGGR(IF(Rank(sum(Spend), 4)&lt;=5,[PProduct Group],'Others'), [PProduct Group])" label is not displaying properly.</P><P></P><P>Need solution for legend label to display properly. Thanks in Advance.</P></BODY></HTML> Wed, 25 May 2016 18:50:03 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139503#M373643 2016-05-25T18:50:03Z Re: Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139504#M373644 <HTML><HEAD></HEAD><BODY><P>Have you tried setting a label?</P><P></P><P><IMG alt="2016-05-25 21_13_20-Document Properties [C__Users_Stefan_Downloads_Dimension Background123 (1) (1).q.png" class="jive-image image-1" src="/legacyfs/online/125799_2016-05-25 21_13_20-Document Properties [C__Users_Stefan_Downloads_Dimension Background123 (1) (1).q.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 May 2016 19:14:31 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139504#M373644 swuehl 2016-05-25T19:14:31Z Re: Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139505#M373645 <HTML><HEAD></HEAD><BODY><P>Yes. I have tried it. Still not working. Please let me know if I am missing somethings.</P><P><IMG alt="pics.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125855_pics.png" style="height: 195px; width: 620px;" /></P></BODY></HTML> Thu, 26 May 2016 03:12:02 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139505#M373645 2016-05-26T03:12:02Z Re: Problem loading Stacked Chart https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139506#M373646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I got solution, thanks for all help.</P><P></P><P>GetCurrentField(&lt;Group Name&gt;) is used in label expression.</P></BODY></HTML> Thu, 26 May 2016 07:43:31 GMT https://community.qlik.com/t5/QlikView/Problem-loading-Stacked-Chart/m-p/1139506#M373646 2016-05-26T07:43:31Z