Chart with Multiple dimensions

[Anonymous]

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

[a_mullick]

Hi,

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

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

Thanks,

Azam

[Anonymous]

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!

[settu_periasamy]

can you provide the sample?

[Anonymous]

Hi Settu,

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

[Anonymous]

HI Settu,

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

[settu_periasamy · Accepted solution]

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.

[a_mullick]

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.

[Anonymous]

Thanks Settu

[Anonymous]

Thanks Azam, the colors are helpful