topic Re: Can I combine these two graphs in one object? in QlikView

Can I combine these two graphs in one object?

alexbjorlig — Fri, 16 Oct 2015 12:33:09 GMT

Hi QlikView Community!

My objective is to combine two graphs in one object.

I created a sample to demonstrate, attached.

Screenshot:

I hope it is possible.

Brgds, Alex

Re: Can I combine these two graphs in one object?

jonathandienst — Fri, 16 Oct 2015 13:00:51 GMT

The problem is that they have a different second dimension. This will prevent you from putting them in a single chart.

But if you create a cyclic group with Employee Name and Employee Team, you could flip between the two dimensions. You could also use a combo chart with conditional display of bars for the one and lines for the other (as long as that is not confusing to your users). Use GetCurrentField() in the expression conditionals to control which expression(s) should display for which cyclic value.

Re: Can I combine these two graphs in one object?

Fri, 16 Oct 2015 13:05:03 GMT

Depending on what you are trying to do, you can add the employee name as a third dimension to the bar chart. This will give you totals by time within week, and a breadkup of the individual within each team - see attched

cycle groups with the 2 different dimenstions as mentioned earlier would work as well

Re: Can I combine these two graphs in one object?

sunny_talwar — Fri, 16 Oct 2015 13:05:48 GMT

May be something like this:

Layered one chart on the other with some formatting changes to make sure they don't look like two charts.

Re: Can I combine these two graphs in one object?

ramasaisaksoft — Fri, 16 Oct 2015 13:23:29 GMT

Hi Alex,

As per my knowledge it is simple to Remove borders and Hide the the Title of chart so that front end view seems like these are one chart only

May be it will help to u

else please ignore this

Re: Can I combine these two graphs in one object?

jonathandienst — Fri, 16 Oct 2015 13:44:42 GMT

This can be very confusing to users. If they try to click on the bar (on the "behind" chart), they are likely to select a line instead. Selections of an employee or employee group could also cause the two to rescale to a different values so they no longer align.

So for this to work well you normally need to make them read-only and/or ignore selections in all the expressions and/or use suitable calculated scaling expressions in the axis tabs for the two charts.

Re: Can I combine these two graphs in one object?

sunny_talwar — Fri, 16 Oct 2015 13:47:09 GMT

I agree, its not the best of ways to create this chart, but its a work around and can be explored more to see if it gives Alex what he wants

Re: Can I combine these two graphs in one object?

alexbjorlig — Tue, 20 Oct 2015 08:13:53 GMT

Hi Adam.

Thanks for your really great example, I really liked it.

Re: Can I combine these two graphs in one object?

Anil_Babu_Samineni — Wed, 01 Jun 2016 12:23:58 GMT

Sunny,

is there anyway to do two graphs in one Graph. My problem is if i am moving any one graph i want to move two graphs ..