Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between straight table and pivot table

I m new to qlikview.

Can you please explain diff between s and p table?

6 Replies
Nicole-Smith

From QV Help:

Pivot TableThe pivot table presents dimensions and expressions in table form. There is no formal limit to the number of dimensions or expressions possible.
A pivot table can be defined without expressions, generating a tree view for navigating the dimension levels.
Straight TableThe straight table differs from the pivot table in that it can not display subtotals and that the grouping of dimensions is shown in record form so that each row of the table contains field and expression values.
Colin-Albert

Some of the key difference are:

Straight tables allow interactive sorting, sorting is fixed by the sort order property in pivot tables.

Pivot tables allow you to have dimensions displayed on both rows and columns.

It used to be the case that straight tables only had a grand total, whereas pivot tables could have sub-totals by using the partial sum option. This is not such a clear-cut difference now that dimension limits allow sub-totals to be included in straight tables.

There is no dimension limits tab in Pivot Tables

MK_QSL
MVP
MVP

Further....

No Grouping is possible in straight table..

You can't hide any column Pivot Table....

http://community.qlik.com/thread/73963

http://community.qlik.com/thread/23380

MK_QSL
MVP
MVP

Also, multi selection is not possible in Pivot Table...

Anonymous
Not applicable
Author

One more attempt...

Pivot table is grouped by dimensions.  Hence it is not possible to sort in any order, but possible to have subtotals by dimensions.  Changing the order of dimensions modifies the table.

Straight table combines all possible values of dimensions.  Order of columns and rows is irrelevant, so you can sort in any way.  Subtotals don't make sense, but total is more flexible - can be "expression total" (as in pivot), or sum (avg, count max, min, etc...) of rows.

Regards,

Michael


brijesh1991
Partner - Specialist
Partner - Specialist

Pivot takes only expression total, while you can have sum of rows, total mode or expression total

--you can hide columns in stright table, u cant do that with pivot

--perfomance: faster in straight than pivot