topic Regarding choosing between Pivot Table and Straight Table. in QlikView https://community.qlik.com/t5/QlikView/Regarding-choosing-between-Pivot-Table-and-Straight-Table/m-p/445838#M561439 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Does it help improve performance or reduce response time if we use a pivot table with dimensions collapsed instead of a Straight table.</P></BODY></HTML> Fri, 15 Mar 2013 14:23:24 GMT 2013-03-15T14:23:24Z Regarding choosing between Pivot Table and Straight Table. https://community.qlik.com/t5/QlikView/Regarding-choosing-between-Pivot-Table-and-Straight-Table/m-p/445838#M561439 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Does it help improve performance or reduce response time if we use a pivot table with dimensions collapsed instead of a Straight table.</P></BODY></HTML> Fri, 15 Mar 2013 14:23:24 GMT https://community.qlik.com/t5/QlikView/Regarding-choosing-between-Pivot-Table-and-Straight-Table/m-p/445838#M561439 2013-03-15T14:23:24Z Re: Regarding choosing between Pivot Table and Straight Table. https://community.qlik.com/t5/QlikView/Regarding-choosing-between-Pivot-Table-and-Straight-Table/m-p/445839#M561440 <HTML><HEAD></HEAD><BODY><P>Only testing can answer that!</P><P>Pivot with collapsed dimensions againts a straight table should be tested for perfomance.</P><P></P><P>Generally straight tables have better perfomance than pivot tables, but they serve different purposes. So there is no straight answer to your question! If you need a pivot then you must use a pivot regardless of perfomance. if you don't need a pivot then definitely use a straight table.</P></BODY></HTML> Fri, 15 Mar 2013 14:43:43 GMT https://community.qlik.com/t5/QlikView/Regarding-choosing-between-Pivot-Table-and-Straight-Table/m-p/445839#M561440 giakoum 2013-03-15T14:43:43Z