topic Re: Performance Issue in QlikView https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714477#M257113 <HTML><HEAD></HEAD><BODY><P>Follow this document </P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-4556">Best Practices for Data Modelling</A></P></BODY></HTML> Mon, 29 Sep 2014 10:35:00 GMT sujeetsingh 2014-09-29T10:35:00Z Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714476#M257112 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I am facing an issue with UI performance and response time.</P><P>My data model</P><P>Table 1 </P><P>CustomerID ,</P><P>Brand,</P><P>Status,</P><P>Quantity,</P><P>----</P><P>---</P><P>---</P><P>Other dimensions.</P><P></P><P>Table 2</P><P>Order ID</P><P>CustomerID</P><P>Location</P><P>Delivered</P><P>....</P><P>...</P><P></P><P>Now i am using bar charts and accumulation with count distinct CustomerID&nbsp;&nbsp; as&nbsp; expression.</P><P>In order to enhance the performance am trying to implement sum() but not seeing any concrete way as CustomeID have one to many relation with OrderID.</P><P></P><P>Any Idea.</P></BODY></HTML> Mon, 29 Sep 2014 08:23:27 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714476#M257112 2014-09-29T08:23:27Z Re: Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714477#M257113 <HTML><HEAD></HEAD><BODY><P>Follow this document </P><P></P><P></P><P><A href="https://community.qlik.com/docs/DOC-4556">Best Practices for Data Modelling</A></P></BODY></HTML> Mon, 29 Sep 2014 10:35:00 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714477#M257113 sujeetsingh 2014-09-29T10:35:00Z Re: Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714478#M257114 <HTML><HEAD></HEAD><BODY><P>can you share some more information? like the schema and the qvw size.</P></BODY></HTML> Mon, 29 Sep 2014 10:39:51 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714478#M257114 maleksafa 2014-09-29T10:39:51Z Re: Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714479#M257115 <HTML><HEAD></HEAD><BODY><P>40 MB file size</P></BODY></HTML> Mon, 29 Sep 2014 10:41:18 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714479#M257115 2014-09-29T10:41:18Z Re: Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714480#M257116 <HTML><HEAD></HEAD><BODY><P>40MB size is nothing big, can you upload the document or show us the schema?</P></BODY></HTML> Mon, 29 Sep 2014 10:45:00 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714480#M257116 maleksafa 2014-09-29T10:45:00Z Re: Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714481#M257117 <HTML><HEAD></HEAD><BODY><P>The performace issue&nbsp; you facing, have you directly queried your datasource if there is any issue.</P><P></P><P>If that is fine, would there be any issue with connectivity, just check with one table.</P><P></P><P>try to use just table box, pulling all your field, if there is performance bottleneck as well.</P><P></P><P>40 MB is very small data size, just try to explore all situations.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 29 Sep 2014 10:53:47 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714481#M257117 2014-09-29T10:53:47Z Re: Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714482#M257118 <HTML><HEAD></HEAD><BODY><P>Ok </P></BODY></HTML> Mon, 29 Sep 2014 11:46:26 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714482#M257118 2014-09-29T11:46:26Z Re: Performance Issue https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714483#M257119 <HTML><HEAD></HEAD><BODY><P>Thanks you all for your replies.</P></BODY></HTML> Mon, 29 Sep 2014 11:46:46 GMT https://community.qlik.com/t5/QlikView/Performance-Issue/m-p/714483#M257119 2014-09-29T11:46:46Z