topic Re: what is difference between straighttable and pivottable in QlikView

what is difference between straighttable and pivottable

Fri, 17 Apr 2015 18:41:40 GMT

what is difference between straight-table and pivot-table

Re: what is difference between straighttable and pivottable

MK_QSL — Fri, 17 Apr 2015 18:42:59 GMT

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.

Re: what is difference between straighttable and pivottable

JonnyPoole — Fri, 17 Apr 2015 18:45:54 GMT

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.