Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SkitzN27
Creator
Creator

Display any text on the bar chart in Qlik Sense

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

Screen Shot 2020-11-02 at 5.16.30 PM.png  --> SkitzN27_0-1604355937055.png

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

 

@Kush 

@dilipranjith 

@Taoufiq_Zarra 

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

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

Capture.PNGDual('Avg: '& Avg(Value), Avg(Value))

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

 

View solution in original post

4 Replies
dilipranjith
Partner
Partner

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

Capture.PNGDual('Avg: '& Avg(Value), Avg(Value))

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

 

View solution in original post

MayilVahanan

Hi @SkitzN27 

Try with Dual function 

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

Number formatting: Measure Expression

Hope it helps

Thanks & Regards,
Mayil Vahanan R
SkitzN27
Creator
Creator

That's awesome, thanks a lot.

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

@dilipranjith 

SkitzN27
Creator
Creator

Thanks so much!