Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
alexmanzoni
Creator
Creator

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
marcarreras
Specialist
Specialist

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

alexmanzoni
Creator
Creator
Author

Thank you marc and prashantbi

Regards

soniardgz
Contributor II
Contributor II

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

QlikView | Pivot Tables - YouTube

QlikView | Straight Table - YouTube