Cannot get new line in bar chart value label

[k_m]

Hi,

Using the Dual function, I have a bar chart where I want to display the % value of each bar and the corresponding #. I've managed to get that working mostly, but cannot seem to insert a new line between the two values.

I've tried:

Dual(Sum([NUMBER MEASURE]) &Chr(10)&
Num(Avg([PERCENTAGE MEASURE]),'#.#%'),
Avg([NUMBER MEASURE]))

which gives me both labels on the same row, like this:

Also tried using Chr(10)&Chr(13), which just makes the labels vertical, like this:

I've tried physically adding a new line within the expression between the '', but that doesn't work either.

Using Qliksense server 13.82.11.

Thank you!

[JordyWegman]

Hi,

Dual is there for combining a textual and numerical value. So this is not going to work.

You can do a couple of things to achieve your goal:

1. Create a container object with 2 bar charts in it and one showing Values and the other Percentages
2. Create one bar chart with a variable measure, based on a toggle that switches between Values and Percentages
3. Create two objects next to each other, so having two bar charts
4. Create a combo chart with a bar chart for the Values and triangles for your Percentages

Jordy

Climber