Diff between straight table and pivot table

[#1]

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]

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]

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]

and also check this thread

Re: Pivot Table vs Straight Table (Performance)

[#5]

Thank you

[awhitfield]

Hi Ashif,

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

Andy