topic How Do I create a comparison Bar Chart Showing 2 Bars for Each Value in QlikView

How Do I create a comparison Bar Chart Showing 2 Bars for Each Value

Wed, 27 Jul 2011 17:01:51 GMT

I am trying to create a chart based on this data and would like the Number of Teddy Bear Accounts to be shown right next the Number of Non-Teddy Bear Accounts for each client type:

CommunityBank:

LOAD [Business Units],

[Type of Client],

[Number of Teddy Bear Accounts],

[Number of Non-Teddy Bear Accounts]

I have managed to create a barchart but they are stacked one on top of the other. Is there anyway I can make them show side by side?

Your help would be much appreciated.

Thank you.

Re: How Do I create a comparison Bar Chart Showing 2 Bars for Each Value

gussfish — Wed, 27 Jul 2011 23:49:00 GMT

Hi Natasha,

open up your chart's properties (right click on the chart & select

Properties) and go to the Style tab. There you'll find radio buttons to

change your chart from Stacked to Grouped.

Angus.

How Do I create a comparison Bar Chart Showing 2 Bars for Each Value

rahulgupta — Thu, 28 Jul 2011 07:16:04 GMT

Hey hi Natasha,

Please check:

Dimentions In your Chart:

1. [Type Of Client]

Expression in your chart:

1. Sum( [Number of Teddy Bear Accounts])

2. Sum( [Number of Non-Teddy Bear Accounts])

Style Tab:

1. Grouped (Agree with Angus)

Hope thi helps

Regards

Re: How Do I create a comparison Bar Chart Showing 2 Bars for Each Value

Thu, 28 Jul 2011 14:14:29 GMT

Thank you, Rahul, it works now. My error was in 'Dimensions'. Until I changed that, clicking on 'Grouped' did not work.

How Do I create a comparison Bar Chart Showing 2 Bars for Each Value

rahulgupta — Mon, 01 Aug 2011 09:29:05 GMT

My Pleasure....