topic Re: modify bar chart x names in App Development

modify bar chart x names

Fri, 09 Sep 2016 09:36:32 GMT

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?

Re: modify bar chart x names

MK9885 — Fri, 09 Sep 2016 16:16:39 GMT

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?

Re: modify bar chart x names

Anonymous — Fri, 09 Sep 2016 16:36:08 GMT

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

Re: modify bar chart x names

Fri, 09 Sep 2016 20:03:55 GMT

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"...

Re: modify bar chart x names

sunny_talwar — Fri, 09 Sep 2016 20:42:37 GMT

May be like this:

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

Re: modify bar chart x names

Fri, 09 Sep 2016 21:29:08 GMT

Ok perfect the answer is correct!