Text on Axis stacking, Multiple Dimensions

[jfredericks]

Hello,

I am trying to place Text on Axis on a Line Chart in QlikView 12.4. I have the option to add another dimension. Without the added dimension, the Text on Axis works fine, but when I add the other dimension, the Text on Axis will stack on top of each other. Is there a way to only show this value once with multiple dimensions on the x-axis? Or is there a way to ignore the added dimension when writing the Text on Axis?

[Chanty4u]

Hi,

this might help

https://community.qlik.com/t5/QlikView-App-Dev/Show-Text-on-Axis-from-Single-Dimension/td-p/940184

[jfredericks]

Thanks for the reply. My issue is similar, but the second dimension comes from a variable. I wasn't able to replicate the result. Also, I am looking to display a value, not perform any calculation on it. Do you have any suggestions?

[Chanty4u]

For 2 dimensions and 1 expression the second dimension is indicated in the legend and not on the axis.

You can add 0 as a second expression and turn off the legend to make the second dimension show on the axis instead.

[jfredericks]

My second expression was the Text on Axis, which still repeats if I add a 0 expression and turn off the legends.

[Chanty4u]

try one more option.. change font of that dimension on axis tab.

reference:

 https://community.qlik.com/t5/QlikView-App-Dev/Hide-label-text-of-axis/td-p/30225

[jfredericks]

Do you know of a way to limit the text on axis to one line, or how to format the text on axis to limit the size?

[jfredericks · Accepted solution]

In my Alteryx workflow, I grouped by the date and added a count distinct for the dimension, then joined this back with my data. I added an if statement to the text on axis to make sure the count distinct value could not be greater than 1 to avoid the repeating labels.