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

[ronman10]

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

[Zhandos_Shotan]

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]

Hi,

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

Juraj

[agigliotti]

which are your chart dimensions and measures ?

[ronman10]

Hi Andrea,

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

Regards,

Rony

[ronman10]

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]

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]

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

[ronman10]

Hi Daniel,

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

Rony

[ronman10]

Hi Juraj,

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

Rony