Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

morganaaron
Valued Contributor

Bar not central over calculated dimension?

Hi all,

Having issues with a bar chart that uses a class statement as a calculated dimension. The dimension is calculating the sum of rainfall in a given week, and then a class statement bands this into bin widths of 5:

Class(Aggr(Sum(Rainfall), TheWeek), 5, 'Rain')


This is the second dimension on the chart, the first being TheWeek. There's only one expression, which calculates a sum of items sold (simply Sum(Items)).

The graph calculates correctly, but the bar for each week isn't centralised, so it's making it more difficult to read - see the image attached!

Any help on how to solve this? I do have TheDate as another field (which obviously links to each week) but if I'm not using it in the chart and aggregating to week level, should this cause any issues?

Thanks!

1 Solution

Accepted Solutions

Re: Bar not central over calculated dimension?

You're using two dimensions in the bar chart. There will be space reserved for each bar of the second dimension and the bars will be same position for each value of the first dimension.


talk is cheap, supply exceeds demand
2 Replies

Re: Bar not central over calculated dimension?

You're using two dimensions in the bar chart. There will be space reserved for each bar of the second dimension and the bars will be same position for each value of the first dimension.


talk is cheap, supply exceeds demand
morganaaron
Valued Contributor

Re: Bar not central over calculated dimension?

Ah, stupid of me. I'll use a banded colour expression in the expression properties instead.

Thanks.

Community Browser