topic Re: Diff between straight table and pivot table in Archived Groups

Diff between straight table and pivot table

Wed, 23 Jul 2025 14:48:52 GMT

Hi experts,

i want to know the diff between straight table and pivot table...

and in what kind of reports can be use..

plz explain both uses and features ..

Thanks

aasif

Gysbert_Wassenaar — Tue, 17 Nov 2015 06:41:39 GMT

Please search before you ask a question This question has been answer a number of times before: https://community.qlik.com/search.jspa?q=straight+pivot+table+difference

gautik92 — Tue, 17 Nov 2015 07:07:14 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.

gautik92 — Tue, 17 Nov 2015 07:08:01 GMT

and also check this thread

Tue, 17 Nov 2015 09:43:04 GMT

Thank you

awhitfield — Tue, 17 Nov 2015 12:41:33 GMT

Hi Ashif,

if a reply has answered your question, then please mark the appropriate reply as CORRECT.

Andy