topic Calculated Dimension Performance Issue in Water Cooler https://community.qlik.com/t5/Water-Cooler/Calculated-Dimension-Performance-Issue/m-p/366879#M1141 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I have a straight table with a calculated dimension using the aggr() function. The dimension for the aggr function is a field of several million values. I then make selections in some other filters, and should reduce the possible values of the aggr dimension to several thousands. However, charting of the straight table still takes several minutes. </P><P></P><P>So, my questions are as following:</P><P>1. Is it appropriate to use aggr() over a dimension of millions of values to create a dimension in a straight table?</P><P>2. Can reducing possible values of the dimension of the aggr() reduce time of charting the table?</P><P>3. If it is no to 1. and 2 above, what alternatives can I have for a better performance?</P><P></P><P>The report is historical data analysis. I also wonder what data model technique is appropriate for trending analysis with QlikView. I would appreciate for any suggestions and/or examples on this.</P><P></P><P>Thank you very much in advance!</P></BODY></HTML> Wed, 25 Apr 2012 02:15:28 GMT 2012-04-25T02:15:28Z Calculated Dimension Performance Issue https://community.qlik.com/t5/Water-Cooler/Calculated-Dimension-Performance-Issue/m-p/366879#M1141 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I have a straight table with a calculated dimension using the aggr() function. The dimension for the aggr function is a field of several million values. I then make selections in some other filters, and should reduce the possible values of the aggr dimension to several thousands. However, charting of the straight table still takes several minutes. </P><P></P><P>So, my questions are as following:</P><P>1. Is it appropriate to use aggr() over a dimension of millions of values to create a dimension in a straight table?</P><P>2. Can reducing possible values of the dimension of the aggr() reduce time of charting the table?</P><P>3. If it is no to 1. and 2 above, what alternatives can I have for a better performance?</P><P></P><P>The report is historical data analysis. I also wonder what data model technique is appropriate for trending analysis with QlikView. I would appreciate for any suggestions and/or examples on this.</P><P></P><P>Thank you very much in advance!</P></BODY></HTML> Wed, 25 Apr 2012 02:15:28 GMT https://community.qlik.com/t5/Water-Cooler/Calculated-Dimension-Performance-Issue/m-p/366879#M1141 2012-04-25T02:15:28Z Calculated Dimension Performance Issue https://community.qlik.com/t5/Water-Cooler/Calculated-Dimension-Performance-Issue/m-p/366880#M1142 <HTML><HEAD></HEAD><BODY><P>Can you pls explain it with an example?</P></BODY></HTML> Fri, 27 Apr 2012 12:01:22 GMT https://community.qlik.com/t5/Water-Cooler/Calculated-Dimension-Performance-Issue/m-p/366880#M1142 jansen28 2012-04-27T12:01:22Z