topic Bar Graph Question in QlikView

Bar Graph Question

Tue, 11 Mar 2014 13:22:44 GMT

I have data for 3 people for the amount of hours worked in December, January and February.

Instead of having 1 bar per person showing hours worked I would like the chart to show hours per month by person. Example from excel below.

If I can do this without re-loading the data that would be best.

Thanks

Re: Bar Graph Question

jonathandienst — Tue, 11 Mar 2014 13:27:07 GMT

Not sure if I have understood you properly, but just change the order of the dimensions = promote Month above Person.

HTH

Jonathan

Re: Bar Graph Question

Tue, 11 Mar 2014 13:27:28 GMT

Hi Michael,

So put as dimension name and month and put sum(hours) as expression

you should get the right result

best regards

Christian

Re: Bar Graph Question

datanibbler — Tue, 11 Mar 2014 13:28:43 GMT

Hi Michael,

so currently you have only one column per person showing the total nr._of_hrs_worked?

=> Just make three expressions out of this one (guess it's sth. like a sum?) and use
set_expressions to specify a certain month.
(sth. like >>> sum({1<Monat = {"Jan"}>} [hrs_worked]) <<<)

HTH

Best regards,

DataNibbler

Re: Bar Graph Question

veidlburkhard — Tue, 11 Mar 2014 13:28:54 GMT

Hi Michael,

you have to add a second dimension 'Month' into the bar chart.

Please try.

Burkhard