Discussion Board for collaboration related to QlikView App Development.
How are the differences between the Pivot and the Straight table?
Thank you all
Following are differences in
Subtotals is not possible in Straight table.
In a pivot table, expressions can be "rolled up" with subtotals (using the Show Partial Sums setting).
No expressions available. SoSub Totals is not possible.
Interactive sorting of Dimensions is possible.
Interactive sorting of Dimensions is not possible.
Interactive sorting is possible.
It is not possible to drilldown to a deeper level, duplicate values are displayed.
It is possible to drilldown (grouping) to a deeper level by clicking on expand icons.
Drilldown is not possible.
Pivoting is not possible.
A cross-table (pivoting) is possible by dragging dimensions to the top of the header row.
Pivoting is not possible
It is possible to set any of the Total modes like Expression Total and Sum of Rows.
It is not possible to set the Total Mode, by default it uses the Expression Total.
Totalling is not available.
Dimension Limits tab is available for this.
Accumulation of values is possible.
Accumulation of values is not possible directly, you have to write separate expressions.
Accumulation of values is not possible.
Hope this helps you.
View solution in original post
Few more differences:
Hope these points are also useful.
Thank you all guys