topic Re: Add two exppresions in the same bar chart. in QlikView

Add two exppresions in the same bar chart.

Wed, 01 Oct 2014 15:54:20 GMT

Hello,

I have the actual time it takes a person to perform an action. Also I have the time you have to take.
How can I express these in the same graph with two dimensions? Location and type of action.

Re: Add two exppresions in the same bar chart.

Anonymous — Wed, 01 Oct 2014 15:59:17 GMT

Gabriel, could you attach a sample file?

Re: Add two exppresions in the same bar chart.

Wed, 01 Oct 2014 16:09:07 GMT

Did you try Stack chart with 2nd expression as (Time to Take - Actual Time) ?

Re: Add two exppresions in the same bar chart.

Wed, 01 Oct 2014 16:16:11 GMT

Yes, but the second term does not take the second dimesion. Put spare a single axis, the first dimension.

Re: Add two exppresions in the same bar chart.

datagrrl — Wed, 01 Oct 2014 16:24:01 GMT

I would make the second expression a symbol. Is that what you are looking for?

I will attach an example if I can find it.

Edit- Attaching a really basic example.

Re: Add two exppresions in the same bar chart.

veidlburkhard — Wed, 01 Oct 2014 16:27:02 GMT

Hi Gabriel,

why don't you use a combo chart instead and define the second expression not as bar but us symbol.

This would bring you very near to your desired solution.

Hope this helps

Burkhard

Re: Add two exppresions in the same bar chart.

Wed, 01 Oct 2014 18:14:33 GMT

Yes, but the second expression, brings together only by the first dimension.

Ej:

Re: Add two exppresions in the same bar chart.

datagrrl — Wed, 01 Oct 2014 18:31:24 GMT

I see what you are talking about now. I have seen this before and I think I fixed it, but I will have to research it.

Re: Add two exppresions in the same bar chart.

datagrrl — Wed, 01 Oct 2014 18:46:36 GMT

http://autoexec.weebly.com/blog/multiple-dimensions-and-expressions-in-bar-chart

This doesn't really help. But I think it explains this issue and suggests some alternatives in the comments.

Re: Add two exppresions in the same bar chart.

microwin88x — Thu, 02 Oct 2014 15:54:29 GMT

I need to solve the same issue.

How could I do this?

Thanks!

Re: Add two exppresions in the same bar chart.

Colin-Albert — Thu, 02 Oct 2014 16:07:28 GMT

With Bar / Line charts you can have 1 dimension and multiple expressions or multiple dimensions and 1 expression, but you cannot have multiple dimensions and multiple expressions.

Re: Add two exppresions in the same bar chart.

veidlburkhard — Thu, 02 Oct 2014 16:53:24 GMT

Hi Colin,

this is what I also was thinking, at first.

But see the below example where I created a bar chart with two dimensions and 4 expressions...

Regards

Burkhard