Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

what is difference between straighttable and pivottable

what is difference between straight-table and pivot-table

2 Replies

Re: what is difference between straighttable and pivottable

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.

Employee
Employee

Re: what is difference between straighttable and pivottable

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.

Community Browser