Tabular Chart

[Anonymous]

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 ?

[mangalsk · Accepted solution]

Have you tried pivot chart

[Anonymous]

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

[#4]

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

[Kushal_Chawda]

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

[Anonymous]

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

[Kushal_Chawda]

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