Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Stacked Bar Chart with spacing between groups

I am trying to create a sort of stacked bar chart. The dimensions would be two fields ([client name] and [Aging Groups]) the expression is Sum([Open Balance]).

That is how I would create the stacked bar chart,

BUT

I am looking to start each one of the [Aging Groups] at the same place (This is indicated by the black dotted line in the picture below).

My desire outcome would be like the chart below (minus the black dotted line)

ANY  help or ANY ideas about this would be much appreciated!!!

Thanks,

Jim

Photo on 7-1-16 at 12.16 PM #2.jpg

3 Replies
Highlighted
Master II
Master II

Re: Stacked Bar Chart with spacing between groups

Just my opinion:

The main purpose of a stack bar chart is to show how the various parts add to the total. Your chart doesn't allow the viewer to compare the totals.

Why not use 5 separate bar charts or maybe a trellis chart?

Highlighted
Partner
Partner

Re: Stacked Bar Chart with spacing between groups

m w,

I have never worked with the trellis chart before. That seems like a great suggestion for what I want to display.

The only issue i have is the y axis- [client name] being displayed multiple time. I would like it only to be displayed the the first part of the trellis chart. Also is there a way to be able to use like a multicolor to make all the bars in the first chart different from the second, third, etc.??

-Jim

Highlighted
Master II
Master II

Re: Stacked Bar Chart with spacing between groups

I don't think you can control the y axis settings for the individual trellis charts (I've been wrong before).

You can probably set the bar colors using Expression|Background Color.