Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
chandni90
Creator
Creator

Chart with Multiple dimensions

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?

Capture.PNG

Dimension-Plant and Storage location.

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

Capture.PNG

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

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.

View solution in original post

9 Replies
a_mullick
Creator III
Creator III

Hi,

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

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

Thanks,

Azam

chandni90
Creator
Creator
Author

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?

Capture.PNG

settu_periasamy

israrkhan

Can you please take a look at this? Thanks!

settu_periasamy
Master III
Master III

can you provide the sample?

chandni90
Creator
Creator
Author

Hi Settu,

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

chandni90
Creator
Creator
Author

HI Settu,

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

settu_periasamy
Master III
Master III

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
Creator III
Creator III

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.

chandni90
Creator
Creator
Author

Thanks Settu

chandni90
Creator
Creator
Author

Thanks Azam, the colors are helpful