- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Difference between Straight and Pivot Table
Hello Community,
Could any one please share the points about difference between Straight and Pivot Table.?
-- Thanks In advance.
Villyee Anderson.
- Tags:
- new_to_qlikview
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
-- Regards,
Vishal Waghole
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
-- Regards,
Vishal Waghole
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello V,
In pivot table as it names says, you can move columns vertical and horizontally. You also have drill down and up capabilities.
A straight table is a plain table. You are not able to drill. However, you will see a "Dimensions Limit" tab that is very useful when you want to show, for example, top 10 results.
There's a lot of information in the forum, but I would recommend you play with both tables a bit.
Best
JV