Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
May i know the difference between the straight table and the pivot table.
Thanks and Regards,
Rikab
The main difference is sub total & grand total is possible in pivot table and no sub total in straight table.
-Raghu
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.
Hi Raghu,
Thanks for your response! May I know what do you mean by groupings here? Could please explain more...
Thanks,
Attitude
We can drag drop the dimension and make its values appear as columns in pivot table which is not possible in Straight table.
Thanks Erika! But this point was already mentioned above. May I know what exactly meant my groupings mentioned by raghu?
@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
Hi Edgar,
Thanks for responding back to my post though it has not answered my question.
Regards,
Attitude
I believe he means Expanding and Collapsing of Dimensions is possible in Pivot table .Which is not possible in Straight table.
Hi Erika,
Thanks for your reply. I also thought of samething but just wanted to justify my understanding.
Thanks,
Attitude