Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
leivers1
Contributor II
Contributor II

Bar Chart - Add Calculation to X-axis Label

Hi,

 

I have a bar chart with a Number (y axis) and a Project name (x axis). See picture.

There are 2 bars. I would like to be able to calculate the percentage from these two bars. % = (orange/Blue value ) and have this percentage present along the x axis alongside each project name like after the project name text.

I have tried some ways i found on the forum top get it to appear after the project name text but could not get it working correctly

 

Is this possible?

 

Thanks

 

1 Solution

Accepted Solutions
kuba_michalik
Partner - Specialist
Partner - Specialist

Yes, by replacing the x axis dimension with an Aggr calculated one, something like this:

=Aggr(
  Only({{x axis dimension}})&' '&Num(({{orange formula}} / {{blue formula}}), '#0%'),
  {{x axis dimension}}
)

Of course replace the {{}} parts by appropriate field names of formulas

View solution in original post

2 Replies
kuba_michalik
Partner - Specialist
Partner - Specialist

Yes, by replacing the x axis dimension with an Aggr calculated one, something like this:

=Aggr(
  Only({{x axis dimension}})&' '&Num(({{orange formula}} / {{blue formula}}), '#0%'),
  {{x axis dimension}}
)

Of course replace the {{}} parts by appropriate field names of formulas

leivers1
Contributor II
Contributor II
Author

Great! That Works.

 

THanks