Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.