topic Difference between the straight table and pitvot table! in QlikView

Difference between the straight table and pitvot table!

Wed, 03 Mar 2010 07:21:21 GMT

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!

Wed, 03 Mar 2010 08:07:59 GMT

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!

Wed, 03 Mar 2010 18:04:02 GMT

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!

Tue, 27 Mar 2012 16:32:14 GMT

Hi Raghu,

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

Thanks,

Attitude

Difference between the straight table and pitvot table!

Tue, 27 Mar 2012 16:35:25 GMT

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!

Wed, 28 Mar 2012 07:05:58 GMT

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!

ekech_infomotio — Wed, 28 Mar 2012 12:31:07 GMT

@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!

Wed, 28 Mar 2012 15:38:26 GMT

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!

Wed, 28 Mar 2012 16:02:45 GMT

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!

Wed, 28 Mar 2012 16:22:17 GMT

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!

Thu, 01 Nov 2012 07:46:03 GMT

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!

Mon, 04 Mar 2013 09:26:50 GMT

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!

Mon, 04 Mar 2013 09:29:15 GMT

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

Re: Difference between the straight table and pitvot table!

Anonymous — Wed, 24 Aug 2016 17:30:09 GMT

Please, check the correct answer.

thank you

Re: Difference between the straight table and pitvot table!

Siva_Sankar — Thu, 25 Aug 2016 01:42:10 GMT

Difference between Pivot Table $ Straight Table

Re: Difference between the straight table and pitvot table!

aravind_dussani — Thu, 04 Jan 2018 15:58:43 GMT

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.