Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
jcampbell
Partner - Creator
Partner - Creator

Qlik Sense: Stacked Bar Chart with Percentage

I'm creating a stacked bar chart in which I want to show the volume, but by percentage, not the number value. I'm using the following Measure/Expression:

Sum({<[Mode (Segment)]={'A'}>}[PlusMin (Segment)])

In QlikView I could simply choose this to be Relative. In a pie chart I can change it to be "Share" (default setting) under Appearance > Presentation. How can I accomplish this in Qlik Sense?

Thanks,

Josh

1 Solution

Accepted Solutions
jcampbell
Partner - Creator
Partner - Creator
Author

I finally got an answer that can work with this:

Sum({<[Mode (Segment)]={'A'}>}[PlusMin (Segment)]) / Sum(Total{<[Mode (Segment)]={'A'}>}[PlusMin (Segment)])

Then just format it to be percentage by changing formatting to Number and then the first percentage option.

View solution in original post

1 Reply
jcampbell
Partner - Creator
Partner - Creator
Author

I finally got an answer that can work with this:

Sum({<[Mode (Segment)]={'A'}>}[PlusMin (Segment)]) / Sum(Total{<[Mode (Segment)]={'A'}>}[PlusMin (Segment)])

Then just format it to be percentage by changing formatting to Number and then the first percentage option.