topic Help formatting a bar chart in QlikView

Help formatting a bar chart

Thu, 13 Sep 2012 10:25:44 GMT

Is there a way that I can create a bar chart similar to the one illustrated above? I want to show months on the X axis and minutes on the Y axis, and then 'stack' the minutes assigned to each category on top of one another in a single bar.

Re: Help formatting a bar chart

Thu, 13 Sep 2012 10:45:22 GMT

Hi,

See the attached QV application.

Use Month and Categaory as your dimension and minutes as your expression.

In the Style tab use Stacked as the Subtype.

Hope this helps

Regards

Mhatim

Re: Help formatting a bar chart

Thu, 13 Sep 2012 11:16:56 GMT

Thanks for the response - I didn't see the 'stacked' option for bar charts. I couldn't get your sample to run in QV because of the licensing but I followed your instructions and it works great.

Re: Help formatting a bar chart

Thu, 13 Sep 2012 11:21:04 GMT

Another question. The first set of data comes from a project management system, and shows a stacked view of the number of minutes spent on different projects by an individual in a month. Could I add a second bar that shows the number of minutes booked in the timesheet system we have? This wouldn't need to be stacked because it's just one number, I want to show a graphical comparison between the two.