# 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
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
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
2 Replies
Highlighted
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
New Contributor III

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

Hi Joseph,

Thanks you very Much Dear.

Regards,

Seenu