topic Chart with two dimensions and two expressions in QlikView

Chart with two dimensions and two expressions

Tue, 12 Jul 2011 14:31:27 GMT

HI all

I am trying to create a chart that has on the x-axis hour of day. I then have two expressions, one: total activity (displaying this as a bar). Two: Average time from request to activity performed (displaying this as a line). This works fine.

What i would then like to do is:

- For the bar showing total activity, turn this into a stacked bar which shows the type of activity making up the total.

Any help would be much appreciated.

Kind regards,

Dan

Re: Chart with two dimensions and two expressions

swuehl — Tue, 12 Jul 2011 17:02:21 GMT

Hi Dan,

do you want something like this?

I think you need an expression for each type of activity, like

Label = type A, expression =count (if (type='A', type))

Label = type B, expression =count(if (type='B', type))

etc.

Then use style subtype "stacked" and in Expressions display options "line" for the line chart (I also used a second y-axis) and "bar" for the two bar charts.

You probably tried using a second dimension, I think this is problematic because you don't want it to apply to the line chart (and this results in a non-stacked bar chart).

Regards,

Stefan

Re: Chart with two dimensions and two expressions

Fri, 15 Jul 2011 14:57:59 GMT

thanks for you help,

dan