topic Re: To show dimensions on graph like on Pivot in QlikView

To show dimensions on graph like on Pivot

innashna — Sat, 16 Nov 2024 01:25:18 GMT

Hello,

I have a Report which looks like in the attached .

I need to make it like in Pivot chart - 'Central Division' should appear one time for all its Regions and not two times. Is it possible?

Re: To show dimensions on graph like on Pivot

rubenmarin — Sun, 26 Jan 2020 09:48:51 GMT

Hi, if this will be a pivot table Central division should only be shown one time, when you expand the dimension, both regions will be show in the next column. Is it not showing that way?

Re: To show dimensions on graph like on Pivot

innashna — Sun, 02 Feb 2020 10:03:14 GMT

Hi,

I need to show this in bars graph, not table.

Re: To show dimensions on graph like on Pivot

rubenmarin — Sun, 02 Feb 2020 12:19:23 GMT

Hi, ok, now i see why it's difficult. I have played a bit with options and made a custom table to work with region indexes instead of values, so it didn't show all regions for every division (not just the regions of each division).

So dimension is the index but is hiden, another expression with text in axis show the region names.

Still I couldn't remove the extra space it gives in the axis, anyway, I'm not sure if this approach can work with your real data so I didn't keep trying.