Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Stacked Bar Chart

I want to have my chart like this:

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Stacked Bar Chart

Thanks for your response.

I wanted  something like this:

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Re: Stacked Bar Chart

Hi Peter,

Please find attached demo file for your reference.

Regards,

Akshaya

Highlighted

Re: Stacked Bar Chart

Try to change your expressions like:

You would do this with the TOTAL function, so if your expression is sum(Value) percentage would be:

sum(Value) / sum(TOTAL Value)

Where the TOTAL causes the divisor to calculate across all dimensions.  If you have two dimensions in your chart (say in a Pivot) you can do the total across a second dimension:

sum(Value) / sum(TOTAL <Dimension> Value)

If you want to ignore selections on a certain field (so you always look at the total, not the total of selected items) you can use set analysis to ignore some selections in the total:

sum(Value) / sum({<Dimension=}>} TOTAL Value).

After this, change the Presentation options of Bar chart.

Highlighted
Contributor III
Contributor III

Re: Stacked Bar Chart

Thanks for your response.

I wanted  something like this:

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Stacked Bar Chart

I uploaded it, in case someone else needs it.