Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

its_anandrjs
Not applicable

Difference between Pivot Table $ Straight Table

Hi,

What are the Basic and Main differences between Pivot Table $ Straight Table. Please provide info about that.

Anand

Regards

5 Replies
kaushik_solanki
Not applicable

Difference between Pivot Table $ Straight Table

Hi,

     What i have found until now is.

     In pivot table you can drag the dimensions over the expression. Means Dimension shown as column. This is not possible in Straight table.

     In a povit table you can not drag expression in middle of expression, but you can do that in straight table.

     Hope this will help you.

Regards,

Kaushik Solanki

avinashelite
Not applicable

Re: Difference between Pivot Table $ Straight Table

this are the difference which I have observed

Straight Table

* Has Dimension limits

*Repetitive data representation

*We can hide the dimension and expression easily

*no sub total options

*No Pivoting

*Better performance

PivotTable

* Has no Dimension limits

*Tabular format  data representation

*We cannot  hide the dimension and expression easily

*sub total options

*No Pivoting

* Less performance compared to straight table

etc

loveisfail
Not applicable

Re: Difference between Pivot Table $ Straight Table

Avinash, How many dimensions we can use in Straight Table?

Life is so rich, and we need to respect to the life !!!
avinashelite
Not applicable

Re: Difference between Pivot Table $ Straight Table

As per I know their is no limitations on the number of dimensions in straight table as the number of dimension increase it might take more time to generate the chart

Siva_Sankar
Not applicable

Re: Difference between Pivot Table $ Straight Table