Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Single Column Stacked Bar Chart

Hi,

I want to create a single column stacked bar chart showing annual targets which will be displayed next to another chart for reference.   I used an excel file with 2 columns(Region, Target).  I created the bar chart, but the option to choose Stacked doesn't appear under Presentation, just horizontal or vertical.  Is this supported?

1 Solution

Accepted Solutions

Re: Single Column Stacked Bar Chart

For Stacked bar Chart you need two Expression and you can choose this option in Style tab

3 Replies

Re: Single Column Stacked Bar Chart

For Stacked bar Chart you need two Expression and you can choose this option in Style tab

Re: Single Column Stacked Bar Chart

Sort of. You can use a bar chart without dimensions and an expression for each region:

sum({<Region={'RegionA'}>}Target)

sum({<Region={'RegionB'}>}Target)

sum({<Region={'RegionC'}>}Target)

...etc

sum({<Region={'RegionX'}>}Target)

Or if a horizontal bar is acceptable you can use a Block Chart with Region as dimension and something like sum(Target) as expression.


talk is cheap, supply exceeds demand
Luminary
Luminary

Re: Single Column Stacked Bar Chart

Or you can also create it with :

     - 2 dimensions

          + a static dimension like text :  = 'Total'

          + your dynamic dimension : Region

     - 1 expression

Community Browser