Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is difference between straighttable and pivottable

what is difference between straight-table and pivot-table

2 Replies
MK_QSL
MVP
MVP

Stright Table vs Pivot Table

Also, below I got from an old post given by JAGAN MOHAN

Straight Table:

You have to write one or more expressions.

Grouping is not possible.

Sub totals is not possible.

Expression Total and Sum of rows mode is available for expression.

Better performance.

Pivoting of dimension is not possible.

COLAPSE/EXPAND column is not possible.

Pivot Table:

You have to write one or more expressions.

Grouping is possible.

Sub totals is possible.

Expression Total  mode is available for expression.

Poor performance when compared to Straight table.

Pivoting of dimension is possible.

COLAPSE/EXPAND column is possible.

JonnyPoole
Employee
Employee

Both display an aggregated set of data in tabular format. Both are text based but straight tables can also display mini charts .

The pivot table has row headers and column headers as well as nested headers on both. Nested header can be expanded/collapsed via +/- button.  The headers and nested headers  are populated by chart dimensions .  The cells that define the intersection of the row and column header is defined by the chart expression.

The straight table only has column headers. No nesting and no row headers.  They are like a CSV file (rows of data) but each row is an aggregation. 

There are other differences in capabilities but thats the guts of it.