
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- new_to_qlikview
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, Rahul, it works now. My error was in 'Dimensions'. Until I changed that, clicking on 'Grouped' did not work.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My Pleasure....
