topic Re: Table or Pivot? in QlikView

Table or Pivot?

Wed, 08 Apr 2015 12:14:40 GMT

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

Re: Table or Pivot?

robert_mika — Wed, 08 Apr 2015 12:18:34 GMT

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

Re: Table or Pivot?

veeranj — Wed, 08 Apr 2015 12:22:55 GMT

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

Re: Table or Pivot?

Thu, 09 Apr 2015 10:23:19 GMT

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!

Re: Table or Pivot?

ashfaq_haseeb — Thu, 09 Apr 2015 10:34:34 GMT

Hi,

Check this as well.

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

Hope it helps

Regards

ASHFAQ

Re: Table or Pivot?

Tue, 14 Apr 2015 05:28:49 GMT

Thanks Ashfaq

That was really helpful.

Regards,

Kuldeep