Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Creation of straight and pivot tables

when we use pivot and straight tables?

1 Solution

Accepted Solutions
mightyqlikers
Creator III
Creator III

hi pavan,

for example if you want to display region wise month on month sales then better to go for Pivot table

like take region and month as dimension and sum(sales) as expression

then drag the moth over expression it will display as pivot.

Straight table : if you want to dispaly aggregated data then better go for Straight table.

$@M

View solution in original post

8 Replies
oknotsen
Master III
Master III

To show the numbers in stead of visualizing them.

May you live in interesting times!
mightyqlikers
Creator III
Creator III

hi pavan,

for example if you want to display region wise month on month sales then better to go for Pivot table

like take region and month as dimension and sum(sales) as expression

then drag the moth over expression it will display as pivot.

Straight table : if you want to dispaly aggregated data then better go for Straight table.

$@M

View solution in original post

settu_periasamy
Master III
Master III

HirisH_V7
Master
Master

HI,


Pivot table-

1) A pivot table is better at grouping: you can easily see which group a specific row belongs to, and a group can have a subtotal.

2) You can also display a pivot table like a cross table (one or several horizontal dimensions).

3) But when you sort a pivot table, you have to sort it first according to the first dimension, then according to the next, etc.

    You cannot sort it any way you want.

Straight table-

A straight table is better at sorting than a pivot table: you can sort it according to any column.

But it is not so good at grouping. Subtotals are not possible, for instance.


HTH,

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
abirami_palanis
Contributor III
Contributor III

Hi,


Pivot:

    Pivot table shows dimensions and expressions in rows and columns , for example in cross table. We can use pivot table for Group Analysis and Hierarchy based analysis.

    Here columns are always sorted based on first dimension.

Straight:

It is like normal table table structure but we can perform Aggregation.

The grouping of dimension is shown in record form.

In opposition to the pivot table, the straight table cannot display sub totals or serve as a cross table.

ankita_arvind1
Contributor II
Contributor II

Hi Pavan,

Below are the points which can explain in which scenarios we should be using straight table and pivot table.

Straight Table:

  • Straight Tables allow interactive sorting. User can sort according to the requirement.
  • Dimension limit is present. This feature can be used to limit the dimensions and view the result as desired.
  • Columns can be hidden in straight table. Only the desired columns can be shown, rest all can be hidden.


Pivot Table:

  • Sorting is fixed by sort property only. customized sort cannot be done.
  • Dimensions can be displayed on both rows and columns.
  • Pivot tables are better at grouping. Partial sums can be displayed.
  • Cross tables can be created by dragging dimensions.


Not applicable
Author

Pivot Table

The 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,

Straight Table

The 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.

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.

There is no dimension limits tab in Pivot Tables

Not applicable
Author