topic Re: Difference between Straight and Pivot Table in QlikView

Difference between Straight and Pivot Table

vanderson009 — Tue, 05 Aug 2014 09:20:07 GMT

Hello Community,

Could any one please share the points about difference between Straight and Pivot Table.?

-- Thanks In advance.

Villyee Anderson.

Re: Difference between Straight and Pivot Table

VishalWaghole — Tue, 05 Aug 2014 09:21:18 GMT

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

Re: Difference between Straight and Pivot Table

jvitantonio — Tue, 05 Aug 2014 09:23:38 GMT

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