Creating a bar chart of hours worked per person

[#1]

Mighty and benevolent Qlik community,

I am trying to create a chart that allows me to show a bar chart of hours worked per day for resources in my company. So I want something that looks like this:

Now quite clearly I have achieved this. My problem is that I am not that smart so I have done this by creating multiple bar charts and multiple name tabs then I added them to a container. The problem with this is that I cannot dynamically select names.

My question, quite simply, is whether anybody has come across something like this? Alternatively is there a better way of building the structure in Qlikview?

Any help would be appreciated as I will otherwise be tied to be the administrator for this for ever more.

Mike

[awhitfield · Accepted solution]

Hi Mike

have you tried using a trellis chart?

Andy

[#3]

Thanks Andrew, I spent hours clicking buttons looking for that, perfect!

[awhitfield]

You're Welcome!

Andy