Trying to create a stacked chart with multiple pieces of information on X-Axis

[#1]

Hi,

Im having trouble creating a new chart in Qlikview.

I have my Y-axis (a list of numbers)

And my X-axis (a list of peoples names)

I need to add 2 variables to the chart, one that will count the number of times a person has Driven to work, aqnd the number of times that same person has walked to work. These need to be shown on a bar chart, with the bars stacked on top of one another. (An example of what I mean has been added as a JPG.)

I have a database the information is being pulled from, and have tried using counts to display the information. I have got this to work, but for only one of the pieces of information. This is displayed correctly, with a bar above each persons name. However, the second piece of information is not stacked on the chart, it is simply its own bar at the end of the chart that is accumulating all of the value, where as it should be delegating individual values to people. This might make more sense when the pictures have been viewed.

Any ideas how I can get this to work?

Thanks..

[#2]

It looks like Workload on Hold is not connected by name, but by WorkloadName, which is why it would be showing Null for 'Name'...

[#3]

Below are the requested screenshots.

When changing the style to a stacked chart, It changles the chart to an even stranger one. Screenshot below.

[#4]

Put 'Workload Name' as your only dimension. Change Style to 'Stacked'. Put two expressions (NOT using & sign; instead click 'Add' and enter second expression):

Count(Workload)

Count(WorkloadOnHold)

[#5]

Should look like this:

[#6]

Unfortunaetly still doesnt work.

[#7 · Accepted solution]

After weeks of working on this, I found the answer. It was a calculated single dimension I needed to use that combined the 2.