Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Differences between tables

Hi guys,

What are the differences between pivot table and normal table?

Thanks

1 Solution

Accepted Solutions
prma7799
Master III
Master III

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

prma7799
Master III
Master III

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

Anonymous
Not applicable
Author

Thank you marc and prashantbi

Regards

Anonymous
Not applicable
Author

In these videos you can watch in a better way the difference between tables.

QlikView | Pivot Tables - YouTube

QlikView | Straight Table - YouTube