Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Fonlovedog207
Contributor
Contributor

How to create graph % and value in one graph

I want to create this graph

Fonlovedog207_0-1671506730134.png

but 

1. % and value overlap

2. Gap between % and value

Fonlovedog207_1-1671506943376.png

 

Labels (4)
1 Reply
rubenmarin

You can try using Dual() for the dot expression, the first parameter for the value to show, the second to position the dot like:

Dual(Num(%Expression,'0%'), BarExpression*1.2)

The *1.2 may not be accurate, more complex expression will be needed to keep the same distance, maybe using a variable to calculate the value of the larger bar and from there a fixed numeric distance to use in all bars