Table or Pivot?

[#1]

Hi friends,

I have a option of using Table versus Pivot in my dashboard. In ideal cases which one is favorable and why?

Also, how can i look them feel cool in my dashboard, as a simple table wont be much attractive.

Regards,

Kuldeep

[robert_mika]

Depends on user requirements:

Table gives you straight result, this is more for showing the overall result

With Pivot you can drill down in you calculations to see breakdown of each category.

To look 'cool' just Google them to find some interesting examples

[veeranj · Accepted solution]

Hi,

If you are referring between Staright table and pivot table,then you can use pivot table if you want to to Partial sums on dimensions where as in Straight table you cant.
In Pivot table you can do grouping of dimensions  where as in straight you cant.The same set of dimension value will get repeated for each row in straight table.

Thanks,

Anjee

[#4]

Thanks robert and veeran for your answers.

As given a personal choice, i would choose pivot over table box, because of the reasons mentioned by you both.

Cheers!

[ashfaq_haseeb]

Hi,

Check this as well.

https://community.qlik.com/message/608088#608088

Hope it helps

Regards

ASHFAQ

[#6]

Thanks Ashfaq

That was really helpful.

Regards,

Kuldeep