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: 
ronman10
Creator
Creator

How to show value and % in a stacked bar in qlik sense

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

1 Solution

Accepted Solutions
juraj_misina
Luminary Alumni
Luminary Alumni

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.

View solution in original post

42 Replies
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi!

You can use custom number format in expressions:

  • for stacked expressions - Num(Value, '0.0 %')
  • for stacked dimension values - if(Dim='PercentValue', Num(Value, '0.0 %'), Value)

GoodLuck!

juraj_misina
Luminary Alumni
Luminary Alumni

Hi,

you can use alternative measures, one for values and one for % share.

Juraj

agigliotti
Partner - Champion
Partner - Champion

which are your chart dimensions and measures ?

ronman10
Creator
Creator
Author

Hi Andrea,

Chart dimensions are product and year. Measure is sales volume.

Regards,

Rony

ronman10
Creator
Creator
Author

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

juraj_misina
Luminary Alumni
Luminary Alumni

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.

dberkesacn
Partner - Creator III
Partner - Creator III

you are not able to show the segments' values just the total bar (# or %) if I remember correctly.

ronman10
Creator
Creator
Author

Hi Daniel,

That is right. I want to see values and % share for each and every segment of the stacked bar.

Rony

ronman10
Creator
Creator
Author

Hi Juraj,

Could you give me the exact expression. Where would Product come in your expression.

Rony