topic Re: Creating a bar chart of hours worked per person in QlikView

Creating a bar chart of hours worked per person

Wed, 18 Mar 2015 14:38:33 GMT

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

Re: Creating a bar chart of hours worked per person

awhitfield — Wed, 18 Mar 2015 14:59:59 GMT

Hi Mike

have you tried using a trellis chart?

Andy

Re: Creating a bar chart of hours worked per person

Wed, 18 Mar 2015 16:33:11 GMT

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

Re: Creating a bar chart of hours worked per person

awhitfield — Wed, 18 Mar 2015 16:39:39 GMT

You're Welcome!

Andy