15 Replies Latest reply: Jan 4, 2018 10:59 AM by aravind reddy

# 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

• ###### 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

• ###### 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.

• ###### 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

• ###### Re: Difference between the straight table and pitvot table!

Hi At titude, According to my knowledge grouping/hiding is possible in pivot table which is shown in below image.plz find.  in the above image we can group/hide the dimensions by using a plus symbol.

and another type of groupings also possible in QlikView.they r DrillDown n Cyclic groups as in below image. in the above image, two types of grouping symbols r shown.

sorry if my answer is wrong n let me know the right answer.

• ###### 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.

• ###### 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?

• ###### 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

• ###### 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

• ###### 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.

• ###### 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

• ###### Re: Difference between the straight table and pitvot table!

1)Grouping is possible in pivot table

2)Partial sums are possible in pivote table

3)sort individual columns in straight table

4)hide the columns in straight  table

5)accumulation is not in pivot table

Regards

• ###### Re: Difference between the straight table and pitvot table!

Hi Arya,

Can you please tell me if there is a way to stop the Grouping? I need it as a part of my project

• ###### Re: Difference between the straight table and pitvot table!

Check this discussion, it will give you better understanding. http://community.qlik.com/thread/73963