topic Tabular Chart in QlikView

Tabular Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Can a following straight table chart be created in Qlikview ?

Specifically referring to the 12 months to be displayed vertically. If so, could you please explain how it can be achieved ?

Re: Tabular Chart

mangalsk — Thu, 20 Jul 2017 10:25:13 GMT

Have you tried pivot chart

Re: Tabular Chart

Anonymous — Thu, 20 Jul 2017 10:27:38 GMT

Yes, but I couldn't seem to understand how to get the month display to be vertical rather than horizontal

Re: Tabular Chart

Thu, 20 Jul 2017 10:31:55 GMT

The pivot table will help. Have 3 dimensions, year,month, one for implemented etc and move the 3rd dimension horizontally.

Re: Tabular Chart

Kushal_Chawda — Thu, 20 Jul 2017 12:45:12 GMT

You can create the Pivot table with Dimension Year, Month. Then create all the expression for Implemented, Failed, Failed with Impact etc.

Remove the caption of pivot table. You can put the text objects for captions Implemented, Failed, ...... just above the pivot table and adjust the width and height of text object with pivot table expression

Re: Tabular Chart

Anonymous — Thu, 20 Jul 2017 12:56:29 GMT

Thanks for your reply Kushal. Is there any way I can remove the labels for the year and month showing up in the table?

Re: Tabular Chart

Kushal_Chawda — Thu, 20 Jul 2017 13:03:30 GMT

Go to dimension tab, click on dimension, then put =' ' in dimension label