Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Difference between the straight table and pitvot table!

Hi All,

May i know the difference between the straight table and the pivot table.

Thanks and Regards,

Rikab

15 Replies
Not applicable

Difference between the straight table and pitvot table!

The main difference is sub total & grand total is possible in pivot table and no sub total in straight table.

-Raghu

Not applicable

Difference between the straight table and pitvot table!

Hope this helps,

straight table pivot table

1) No groupings in straight table grouping is possible

2) grand total, no sub total sub total & grand total is possible

3) Hiding is possible in straight table (Dimension) Hiding is not possible in pivot table

4) Interactive sorting is possible Interactive sorting is not possible

-Raghu.

Not applicable

Difference between the straight table and pitvot table!

Hi Raghu,

Thanks for your response! May I know what do you mean by groupings here? Could please explain more...

Thanks,

Attitude

Not applicable

Difference between the straight table and pitvot table!

We can drag drop the dimension and make its values appear as columns in pivot table which is not possible in Straight table.

Not applicable

Difference between the straight table and pitvot table!

Thanks Erika! But this point was already mentioned above. May I know what exactly meant my groupings mentioned by raghu?

ekech_infomotio
Contributor II

Difference between the straight table and pitvot table!

@At titude:

Please ask the manual or the help system - it has lots of answers for you and your questions. Also, it would help, if you were trying to learn some basics of Aggregation, Grouping and Pivot-Tables. This is very basic knowledge which isn't Qlikview-specific and everything relevant for Qlikview has been written before by Rhagu and Erika.

BTW - stop apologizing for your questions - I know you will ;-)

Regards,

Edgar

Not applicable

Difference between the straight table and pitvot table!

Hi Edgar,

Thanks for responding back to my post though it has not answered my question.

Regards,

Attitude

Not applicable

Difference between the straight table and pitvot table!

I believe he means Expanding and Collapsing of Dimensions is possible in Pivot table .Which is not possible in Straight table.

Not applicable

Difference between the straight table and pitvot table!

Hi Erika,

Thanks for your reply. I also thought of samething but just wanted to justify my understanding.

Thanks,

Attitude

Community Browser