Display any text on the bar chart in Qlik Sense

[SkitzN27]

Hi Guys,

I believe it should be a pretty simple one but how can I display any text on the bars itself in bar chart in Qlik Sense?

For instance, I'm calculating the sum and average for some sample data

  --> 

Is it possible to display text along with the total number as highlighted in the paper? OR Any workaround? (It's okay to display it inside the bars)

My data is:

load * Inline [

Dim, Value
1, 1000
2, 500,
3, 200
4, 50
5, 10
];

My measures are-

For Average:    Avg({<Dim=>}Value)

For Sum: Sum({<Dim=>}Value)

I tried using the Dual function but it didn't display 'Avg' or 'Sum'

Thank you

@Kushal_Chawda 

@dplr-rn 

@Taoufiq_Zarra 

[dplr-rn · Accepted solution]

1- Use expression with dual. Dual('Sum: '&Sum(Value),Sum(Value)) 

Dual('Avg: '& Avg(Value), Avg(Value))

2- change Number formatting for measure from auto to Measure Expression

[MayilVahanan]

Hi @SkitzN27 

Try with Dual function 

Dual('Sum :' & Num(Sum({<Dim=>}Value),'#,##0'), Sum({<Dim=>}Value))

Number formatting: Measure Expression

Hope it helps

[SkitzN27]

That's awesome, thanks a lot.

I didn't change the number formatting, it works well.

@dplr-rn 

[SkitzN27]

Thanks so much!