Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
morganaaron
Specialist
Specialist

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
Gysbert_Wassenaar

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Specialist
Specialist
Author

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

Thanks.