Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: 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