Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
syahfira
New Contributor II

Percentage and Number value on Bar and Stacked Chart

Hi Qlik Community

I need help on this so much.

I would like to know how we can add percentage and number value together in labels.

I used the appearance button in Qlik Sense. But, it just for number value.

How I can add percentage value together with it?


Percentage Value Label on Chart.jpg

How can I add the percentage and number value for each bar in stacked chart ?

Add percentage into stacked bar chart.jpg

Thanks so much everyone for the help.

5 Replies
dilipranjith
Honored Contributor

Re: Percentage and Number value on Bar and Stacked Chart

Dont believe it is available by default. i think you need extensions for this.

Khan_Mohammed
Honored Contributor II

Re: Percentage and Number value on Bar and Stacked Chart

You cannot exactly show both numbers and % in single expression

But in mouse hover over you can show both values...

Example:

In your Measure label

'Year = ' & Expression1 & chr(10) &

'% Value = ' & Expression2 & chr(10)

OmarBenSalem
Esteemed Contributor II

Re: Percentage and Number value on Bar and Stacked Chart

what u can do is adding one of the measure besides the dimension: sthing like:

as dim : urDim & aggr(sum(YourMeasure),urDim)

as measure: the % measure

justinphamvn
Contributor II

Re: Percentage and Number value on Bar and Stacked Chart

Hi,

You can try with Barplus (Extension)

Link: barsPlus - Qlik Branch

alt text

Hope this helps,

Justin.

syahfira
New Contributor II

Re: Percentage and Number value on Bar and Stacked Chart

Hi everyone

Thanks so much for helping me out.

I got to know and learnt new things from all the answers.

I didn't use this chart anymore since the user wanna have something else.

Hope in future this thread would be helpful and beneficial for others.

Thank You.