Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

Hi 

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.

1 Solution

Accepted Solutions
rahulgupta
Contributor III

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

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

4 Replies
gussfish
Contributor II

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

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.

rahulgupta
Contributor III

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

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

Not applicable

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

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

rahulgupta
Contributor III

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

My Pleasure....

Community Browser