Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi @SkitzN27
Try with Dual function
Dual('Sum :' & Num(Sum({<Dim=>}Value),'#,##0'), Sum({<Dim=>}Value))
Number formatting: Measure Expression
Hope it helps
Thanks so much!