Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a slightly messy grouped bar chart and need to make it easier to read, therefore I would like to add verticle dividing lines between each Salesperson, as per the crude black lines I have drawn on.
Rather annoyingly the default gridlines seem to sit in the middle of the Salesperson's grouped bars (on July), which doesn't help as I need them between th salespeople. Any aide how i would do this?
Not possible. I would instead look at increasing the distance between the groups (Chart Properties -> Presentation -> Cluster Distance).
Or - an alternative would be to show this as a Trellis graph (Chart Properties -> Dimensions -> Trellis). Doing so will create a mini-chart for each value of the first dimension.
HIC
Not possible. I would instead look at increasing the distance between the groups (Chart Properties -> Presentation -> Cluster Distance).
Or - an alternative would be to show this as a Trellis graph (Chart Properties -> Dimensions -> Trellis). Doing so will create a mini-chart for each value of the first dimension.
HIC
great. Thanks for your help Henric
Hello,
I would also suggest to go for a stacked bar chart view.
Thanks
Isn't this quite a basic thing for Qlikview to have though? When I create a bar chart I would always want the gridlines to group together the data for each dimension title, otherwise it looks messy.
I understand on a line chart you would want it in the middle of the title but not on a bar.
Gareth
Looks like there is workaround:
Main idea of solution is to create under main chart (let’s call it 1st chart) background chart (2nd chart) with enabled Minor Grid. Minor grid will be situated exactly between bar groups.
Though as far as I can see it, it is impossible to switch off main grid with minor grid enabled at the same time, but we can hide it by bars of the same color as background.
Here what result will look like (you can also find attached qvw file):
Solution is quite interactive: you can make selections and dividers will adjust accordingly.
Here are specific basic steps i suggest to follow: