topic How to generate chart using subset of data? in QlikView https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217584#M70771 <HTML><HEAD></HEAD><BODY><P>Hi Lewis,</P><P>Try to do the sumation in the script level (back end) as a seperate table &amp; field. Bring the new field into chart.</P><P>Regards</P><P>Rajesh</P><P></P></BODY></HTML> Mon, 19 Apr 2010 06:34:30 GMT 2010-04-19T06:34:30Z How to generate chart using subset of data? https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217583#M70770 <HTML><HEAD></HEAD><BODY><P>I created an application based on a large amount of data (over 18 million records). I'm experiencing a very bad performance (e.g. taking forever to generate) on one of the chart with "full accumalation" option selected.</P><P>I tried to improve its perforamnce by using sampling records (e.g. sum(if), set analysis, mulitiplication). It takes about 15 seconds to reload when I trim down the total number of records to around 3 million records by filtering records. However, when I refresh this application using using full set of data (18 million records), it took about 8 minutes to reload this chart while the rest of the charts \ tables are reloaded within a few seconds.</P><P>I need to load the full data set in the applicaton as they are needed to generate other charts \ tables. Is there any other way I can further improve the performance of this chart? Thanks.</P></BODY></HTML> Mon, 19 Apr 2010 05:27:56 GMT https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217583#M70770 2010-04-19T05:27:56Z How to generate chart using subset of data? https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217584#M70771 <HTML><HEAD></HEAD><BODY><P>Hi Lewis,</P><P>Try to do the sumation in the script level (back end) as a seperate table &amp; field. Bring the new field into chart.</P><P>Regards</P><P>Rajesh</P><P></P></BODY></HTML> Mon, 19 Apr 2010 06:34:30 GMT https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217584#M70771 2010-04-19T06:34:30Z How to generate chart using subset of data? https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217585#M70772 <HTML><HEAD></HEAD><BODY><P>Hi Rajesh,</P><P>Actually, I've a complex but high flexibility data model which allow to analysis data in many different dimensions in this application. If I build a summaried table based only base on 1 or a few dimensions, it will limit the flexibility of the application. Is there any other possible way to improve the performance in this case? Thanks a lot for your suggestion <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Regards,<BR />Lewis</P></BODY></HTML> Mon, 19 Apr 2010 06:51:02 GMT https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217585#M70772 2010-04-19T06:51:02Z How to generate chart using subset of data? https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217586#M70773 <HTML><HEAD></HEAD><BODY><P>Hi Lewis,</P><P>Based on you complex conditions, can you able to raise some flag in the back end script and make use of them in the expression.</P><P>Regards</P><P>Rajesh</P></BODY></HTML> Mon, 19 Apr 2010 07:12:07 GMT https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217586#M70773 2010-04-19T07:12:07Z How to generate chart using subset of data? https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217587#M70774 <HTML><HEAD></HEAD><BODY><P>Hi Rajesh,</P><P>I added a flag in my script and tried to make use of it in the dimension and expression as well. But it doesn't help much in my case. Is there anything else I should try?</P><P>Regards,</P><P>Lewis</P></BODY></HTML> Mon, 19 Apr 2010 09:16:22 GMT https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217587#M70774 2010-04-19T09:16:22Z How to generate chart using subset of data? https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217588#M70775 <HTML><HEAD></HEAD><BODY><P>Hi Lewis,</P><P>Can you share the expression?</P><P>How many dimensions are using in your chart? Is there any calculated dimensions?</P><P>Regards</P><P>Rajesh</P></BODY></HTML> Mon, 19 Apr 2010 09:21:19 GMT https://community.qlik.com/t5/QlikView/How-to-generate-chart-using-subset-of-data/m-p/217588#M70775 2010-04-19T09:21:19Z