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: 
lawrenceiow
Creator II
Creator II

Aligning Values on Data Points

How do I left align my Values on Data Points?

I have a bar chart, orientation = horizontal, stacked (see image below).

My Dimension uses the Class function to apply a grouping, end user can vary the size of the group via slider.

I have three Expressions:

  1. Percentage on Target (green)
  2. Percentage not on Target (pink)
  3. Text to show actual numbers rather than percentage (Values on Data Points is ticked only, not Bar)

In the Presentation tab I have ticked "Plot Values Inside Segments"

How do I left align the Values on Data Points? They are centred horizontally within the bar and I would like them left aligned.

Thank you.

Image
Untitled2.png
5 Replies
settu_periasamy
Master III
Master III

May be you can try with Dual function in your expression. Like

=dual(sum(Value)&Repeat(chr(8203),10),sum(Value))

lawrenceiow
Creator II
Creator II
Author

Thank you for your reply.

I couldn't see how your suggestion would help but I tried it anyway. Here is the result.

Image 1

Untitled.png

What I am looking for is a way to align the data values to the left, like in the image below (I have used an image editor to move the text here).

Image 2
Untitled1.png
settu_periasamy
Master III
Master III

We don't have the direct option to do that. We need to add some invisible space (chr(8203)) to look like a left aligned.

for e.g you can see with the below expression

=dual(sum(Value)&Repeat('A',10),sum(Value))


the result will show with 10 'A' s.

lawrenceiow
Creator II
Creator II
Author

I understand what your expression does but it does not solve my problem, sorry.

Thank you for trying though.

Not applicable

I'm facing the same issue in some of my applications and couldn't find a working solution so far. Anyone any idea? Thanks in advance.