topic Re: Chart with Multiple dimensions in QlikView

Chart with Multiple dimensions

Anonymous — Tue, 21 Feb 2017 18:52:41 GMT

Hi,

I want my chart to display like the one below. However, giving the second dimension(storage location) colors all the bars instead of showing the storage location names as a second dimension. How do I achieve this?

Dimension-Plant and Storage location.

Expression- sum([Total Value USD])/1000000

Re: Chart with Multiple dimensions

a_mullick — Thu, 23 Feb 2017 17:02:17 GMT

Hi,

Perhaps not as simple as it should be. See if this helps...

https://community.qlik.com/thread/187258

Thanks,

Azam

Re: Chart with Multiple dimensions

Anonymous — Mon, 27 Feb 2017 21:04:52 GMT

Thanks Azam.

I have added Plant, storage location and another dummy dimension.

Expression: sum(distinct([Total Value USD]))/1000000

It seems to work fine except that the storage locations are all haphazardly arranged. It doesnt show clearly the storage locations belonging to each plant. Can you help?

settu_periasamy‌

israrkhan‌

Can you please take a look at this? Thanks!

Re: Chart with Multiple dimensions

settu_periasamy — Fri, 03 Mar 2017 18:42:21 GMT

can you provide the sample?

Re: Chart with Multiple dimensions

Anonymous — Mon, 06 Mar 2017 20:24:55 GMT

Hi Settu,

I have attached the data set and the sample qvw. Thanks!

Re: Chart with Multiple dimensions

Anonymous — Tue, 07 Mar 2017 16:20:35 GMT

HI Settu,

Just checking if you were able to find out anything? Thanks!

Re: Chart with Multiple dimensions

settu_periasamy — Wed, 08 Mar 2017 19:48:25 GMT

Hi,

I'm not sure, we have this option.

But, what i did is, combined both field(Plant & storage location) with Proper length and applied 'x-axis scroll bar'.

Not sure, it is suitable for you. just a have a look the attachment.

Re: Chart with Multiple dimensions

a_mullick — Fri, 10 Mar 2017 12:03:23 GMT

Hi,

I think given the number of potential bars that you have in this chart, Settu's solution works well. I've made a minor change and added some colours, which you may, or may not, think help...they are defined in sheet 2 of the Excel workbook, so you can change them to a different colour scheme.

Azam

p.s. Obviously I'm not aware of your actual requirements, but be careful using SUM(DISTINCT...) you may not get the results you expect if the same value occurs more than once.

Re: Chart with Multiple dimensions

Anonymous — Fri, 10 Mar 2017 16:00:26 GMT

Thanks Settu

Re: Chart with Multiple dimensions

Anonymous — Fri, 10 Mar 2017 16:01:16 GMT

Thanks Azam, the colors are helpful