Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have created a stacked bar in qlik sense and want to see the values as well as % share for the different segments in the stack. How do I achieve this? Please advise.
Regards,
Rony
OK, so the dimension is not [Year], but [Date.autoCalendar.Year], which means the expression should be:
Sum([Volume])/Sum(TOTAL <Date.autoCalendar.Year> [Volume])
EDIT: I also changed [Sales Volume] to [Volume] according the screenshot.
Hi!
You can use custom number format in expressions:
GoodLuck!
Hi,
you can use alternative measures, one for values and one for % share.
Juraj
which are your chart dimensions and measures ?
Hi Andrea,
Chart dimensions are product and year. Measure is sales volume.
Regards,
Rony
Jugal,
When I use an alternative measure, I change the number formatting to %. However, this does not show the % share but just adds the % symbol after the normal value. Am I doing something wrong?
Rony
Adjust your expression to show % to something like this (insert your field names)
Sum([Sales Volume])/Sum(TOTAL <Year> [Sales Volume])
This will calculate products % share within a year, I guess this is what you're aiming at.
you are not able to show the segments' values just the total bar (# or %) if I remember correctly.
Hi Daniel,
That is right. I want to see values and % share for each and every segment of the stacked bar.
Rony
Hi Juraj,
Could you give me the exact expression. Where would Product come in your expression.
Rony