topic Re: What is difference between pivot table and straight table in QlikView https://community.qlik.com/t5/QlikView/What-is-difference-between-pivot-table-and-straight-table/m-p/400580#M149074 <HTML><HEAD></HEAD><BODY><P>A pivot table is better at grouping: you can easily see which group a specific row belongs to, and a group can have a subtotal. You can also display a pivot table like a cross table (one or several horizontal dimensions). But when you sort a pivot table, you have to sort it first according to the first dimension, then according to the next, etc. You cannot sort it any way you want.</P><P></P><P>A straight table is better at sorting than a pivot table: you can sort it according to any column. But it is not so good at grouping. Subtotals are not possible, for instance.</P><P></P><P>HIC</P></BODY></HTML> Sun, 03 Mar 2013 15:12:27 GMT hic 2013-03-03T15:12:27Z What is difference between pivot table and straight table https://community.qlik.com/t5/QlikView/What-is-difference-between-pivot-table-and-straight-table/m-p/400579#M149073 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>What is the differenct between pivot table and straight table ?</P><P></P><P></P><P>Thanks</P><P></P><P></P><P>Vikas</P></BODY></HTML> Sat, 02 Mar 2013 11:49:24 GMT https://community.qlik.com/t5/QlikView/What-is-difference-between-pivot-table-and-straight-table/m-p/400579#M149073 vikasmahajan 2013-03-02T11:49:24Z Re: What is difference between pivot table and straight table https://community.qlik.com/t5/QlikView/What-is-difference-between-pivot-table-and-straight-table/m-p/400580#M149074 <HTML><HEAD></HEAD><BODY><P>A pivot table is better at grouping: you can easily see which group a specific row belongs to, and a group can have a subtotal. You can also display a pivot table like a cross table (one or several horizontal dimensions). But when you sort a pivot table, you have to sort it first according to the first dimension, then according to the next, etc. You cannot sort it any way you want.</P><P></P><P>A straight table is better at sorting than a pivot table: you can sort it according to any column. But it is not so good at grouping. Subtotals are not possible, for instance.</P><P></P><P>HIC</P></BODY></HTML> Sun, 03 Mar 2013 15:12:27 GMT https://community.qlik.com/t5/QlikView/What-is-difference-between-pivot-table-and-straight-table/m-p/400580#M149074 hic 2013-03-03T15:12:27Z Re: What is difference between pivot table and straight table https://community.qlik.com/t5/QlikView/What-is-difference-between-pivot-table-and-straight-table/m-p/400581#M149075 <HTML><HEAD></HEAD><BODY><P>Thanks for better understanding....</P></BODY></HTML> Sun, 03 Mar 2013 16:54:18 GMT https://community.qlik.com/t5/QlikView/What-is-difference-between-pivot-table-and-straight-table/m-p/400581#M149075 vikasmahajan 2013-03-03T16:54:18Z