Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Graph Question

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.

Example Pic.png

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

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Hi Michael,

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

you should get the right result

best regards

Christian

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Hi Michael,

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

you should get the right result

best regards

Christian

datanibbler
Champion
Champion

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

veidlburkhard
Creator III
Creator III

Hi Michael,

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

Please try.

Burkhard