modify bar chart x names

[#1]

I created with Qlik Sense a simple bar chart (city name and total revenue). Currently the name of the bars in the x-axis are "City" (Sand Diego, New York...) but I would like to change them adding a "~" and the relative "performance" (that is a measure). So the final result should be "City ~ Performance" (San Diego ~ 54,67, New York ~ 43,55...).

Is it possible?

[MK9885]

Can you upload test qvf file?

And can you be more specific? What label you need for City?

What label you need for Performance? Ex:

City to what ???

Performance to what ????

Is there any condition for labeling?

[Anonymous]

try using [City Name] &' ~ ' & Aggr(Sum(Revenue),[City Name]) as your dimension

[#4]

Ah ok perfect.... is it possible to round off the Sum(Revenue) to two decimals?

For example "San Francisco ~ 54,55" ... I don't want to see "San Francisco ~ 54,5545567"...

[sunny_talwar · Accepted solution]

May be like this:

Round(Aggr(Sum(Revenue),[City Name]), 0.01)

[#6]

Ok perfect the answer is correct!