Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
bommidoddi
New Contributor III

What is the difference between Straight table And Pivot Table ?

Hi Experts,

Please explain Difference in Straight Table And Pivot Table ?

Regards,

Seennu

1 Solution

Accepted Solutions
jobsonkjoseph
Contributor III

Re: What is the difference between Straight table And Pivot Table ?

Hi,

Few differences are as follows;

Straight Table

Pivot Table

Used when table is having less number of Dimensions and more Expressions

Used when table is having less Expressions and more Dimensions

It is possible to limit the number of Dimension limit tab

There is no Dimension limit tab

Hiding of columns is possible

Not possible

Grand Totals are possible

Sub Totals are possible, by selecting Partial Sums option in Properties>Presentation Tab>Dimensions and Expressions

Not possible

It is possible to convert rows into columns and columns into rows

Interactive Sorting is possible

Grouping is possible

Visual Cue option present

Not available

View solution in original post

2 Replies
jobsonkjoseph
Contributor III

Re: What is the difference between Straight table And Pivot Table ?

Hi,

Few differences are as follows;

Straight Table

Pivot Table

Used when table is having less number of Dimensions and more Expressions

Used when table is having less Expressions and more Dimensions

It is possible to limit the number of Dimension limit tab

There is no Dimension limit tab

Hiding of columns is possible

Not possible

Grand Totals are possible

Sub Totals are possible, by selecting Partial Sums option in Properties>Presentation Tab>Dimensions and Expressions

Not possible

It is possible to convert rows into columns and columns into rows

Interactive Sorting is possible

Grouping is possible

Visual Cue option present

Not available

View solution in original post

bommidoddi
New Contributor III

Re: What is the difference between Straight table And Pivot Table ?

Hi Joseph,

Thanks you very Much Dear.

Regards,

Seenu