topic Horizontal alignment of line values in Combination Chart in QlikView

Horizontal alignment of line values in Combination Chart

Anonymous — Wed, 16 Mar 2011 15:55:01 GMT

Hi everyone,

i have a combination chart with 2 Dimensions:
1. Product group
2. Month

Additionally i have 2 Formulas:
1. Sum of product values (show as bars)
2. Sum of product marginal return (show as line)

The bars are displayed correctly. One bar for each month in one bar-group for each product-group.

Here is the problem: The values of the line (formula 2) are not horizontally aligned in the centers of the single bars but in the centers of the bar-groups. So the single line-values for every single month are all together displayed in one vertical line above the product-group.

How can i get the chart to display the values of the line where they really relate to: the month - not the product-group?

Thanks to all for your help

Horizontal alignment of line values in Combination Chart

tresB — Wed, 16 Mar 2011 17:26:59 GMT

This is possibly something to play with Presentation or Axis. Can the application be uploaded with sample data?

Regards, tresesco

Horizontal alignment of line values in Combination Chart

Anonymous — Thu, 17 Mar 2011 07:44:09 GMT

I'd like to upload a .qvw and .xls file. How can i do this? Looks like the "insert media"-button only allows to upload pictures or something like this.

Horizontal alignment of line values in Combination Chart

tresB — Thu, 17 Mar 2011 15:20:27 GMT

instead of clicking Quick Reply, click on Reply, you would find three tabs there, go to second tab(Options); there you would find the option for attachment.

Horizontal alignment of line values in Combination Chart

Anonymous — Thu, 17 Mar 2011 15:58:44 GMT

Here you are

Horizontal alignment of line values in Combination Chart

Anonymous — Thu, 17 Mar 2011 16:00:31 GMT

and the sample application...

Horizontal alignment of line values in Combination Chart

johnw — Thu, 17 Mar 2011 21:40:00 GMT

There was a thread on something very similar yesterday. It looks like a QlikView bug to me. The two suggested workarounds were to use either a trellis chart or to concatenate the two dimensions into one.

One extra complication with concatenating dimensions in your case is that the line would then be drawn between groups, not just within groups. That can be fixed with an appropriate background color expression though.

Both workarounds attached.

Horizontal alignment of line values in Combination Chart

Anonymous — Fri, 18 Mar 2011 09:30:02 GMT

Thanks for your help.

Both workarounds are possible and work like they expected. I'd prefer the solution with the concatenated dimensions.

Could you please post the background expression which is needed, because i can't open the attached sample file (at the moment i'm testing qlikview for our company with the personal edition)? In which field of the property-window do i have to set the expression?

Is there a way beyond to define dynamic bar groups within 1 dimension?

Again thanks for your help!!

Horizontal alignment of line values in Combination Chart

johnw — Fri, 18 Mar 2011 17:10:05 GMT

I haven't thought of other options for defining dynamic bar groups within 1 dimension. Here's how to split up the line so it doesn't cross groups, and showing the resulting chart.

Horizontal alignment of line values in Combination Chart

Anonymous — Mon, 21 Mar 2011 08:12:39 GMT

Works well!

Thank you!