topic Multi Dimensional Pivot Chart in QlikView

Multi Dimensional Pivot Chart

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

Hi Community.

I have a pivot chart with two dimensions and 3 expressions and I would like to have one dimensions as row and the other as column.

I also have sub totals (partial sums included) in the chart.

Any ideas will be truly greatful

Re: Multi Dimensional Pivot Chart

Sergey_Shuklin — Wed, 25 Jul 2018 04:19:38 GMT

Hello, Zoe!

You can drag dimensions in chart from rows to columns by holding the dimension with LMB.

Re: Multi Dimensional Pivot Chart

Anonymous — Wed, 25 Jul 2018 04:35:44 GMT

Hi Zoe,

You just need to drag the second dimension on top of the chart as below example.

Re: Multi Dimensional Pivot Chart

qlikviewwizard — Wed, 25 Jul 2018 06:56:45 GMT

Hi Try like this.

Pull Region to the right and keep above the expression. Please check the attached file as well.

Re: Multi Dimensional Pivot Chart

ZoeM — Wed, 25 Jul 2018 12:51:53 GMT

Thanks for the example Arjun.

The only issue I face is that I have subtotals at the top and when I pull the second dimension to the top it is creating categories based on that dimension.

I may have to look into creating a concat field to illustrate the information from the second dimension in order to keep the format of the chart.