Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.