Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
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
Highlighted
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
Highlighted
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