topic Reg:Diffrence between Straight and Pivot table in QlikView

Reg:Diffrence between Straight and Pivot table

Fri, 02 Jul 2010 05:18:44 GMT

Hi All,

I would like to know the diffrence between the charts namely PIVOT and STRAGIHT Table.What is the diffrence bewtween them?

If any of you aware regarding this please let me know the same.

Thanks & Regards

Jai

AW:Reg:Diffrence between Straight and Pivot table

brenner_martina — Fri, 02 Jul 2010 08:03:53 GMT

Hi,

you've not been at a training?

Pivottable groups all data for every dimension in their order and can not be changed in sortorder by the user. You can drag and drop some of the dimensions as a title line above the table.

The straight table shows all data in order of the column you mark by doubleclick asc or desc. here you can also change the order of the columns.

Reg:Diffrence between Straight and Pivot table

Miguel_Angel_Baeyens — Fri, 02 Jul 2010 08:13:58 GMT

Hello Jai,

Pivot tables allow you to show subtotals by dimension, and use dimensions in both columns and rows, while straight tables will show your expressions without grouping totals.

You can expand / collapes pivot tables as well, but not straight tables.

You have detailed documentation in the reference manual pp. 215 onwards.