Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bommidoddi
Contributor III
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

Sreenivasulu B
1 Solution

Accepted Solutions
jobsonkjoseph
Creator III
Creator III

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
Creator III
Creator III

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

bommidoddi
Contributor III
Contributor III
Author

Hi Joseph,

Thanks you very Much Dear.

Regards,

Seenu

Sreenivasulu B