Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
its_anandrjs

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
kaushiknsolanki

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
avinashelite

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

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
avinashelite

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