Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
What are the differences between pivot table and normal table?
Thanks
Hi Alex,
Pivot Table -
1) 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.
2) You can also display a pivot table like a cross table (one or several horizontal dimensions).
3) 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.
Straight Table-
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.
Please check this
http://community.qlik.com/docs/DOC-7681
Thanks
PM
Hi Alex,
Pivot Table -
1) 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.
2) You can also display a pivot table like a cross table (one or several horizontal dimensions).
3) 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.
Straight Table-
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.
Please check this
http://community.qlik.com/docs/DOC-7681
Thanks
PM
Thank you marc and prashantbi
Regards
In these videos you can watch in a better way the difference between tables.