topic Re: Text on Axis stacking, Multiple Dimensions in QlikView

Text on Axis stacking, Multiple Dimensions

jfredericks — Mon, 22 Feb 2021 22:57:55 GMT

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?

Re: Text on Axis stacking, Multiple Dimensions

Chanty4u — Tue, 23 Feb 2021 14:00:28 GMT

Hi,

this might help

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

Re: Text on Axis stacking, Multiple Dimensions

jfredericks — Tue, 23 Feb 2021 15:10:51 GMT

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?

Re: Text on Axis stacking, Multiple Dimensions

Chanty4u — Tue, 23 Feb 2021 15:10:14 GMT

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.

Re: Text on Axis stacking, Multiple Dimensions

jfredericks — Tue, 23 Feb 2021 15:17:42 GMT

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

Re: Text on Axis stacking, Multiple Dimensions

Chanty4u — Tue, 23 Feb 2021 15:21:21 GMT

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

Re: Text on Axis stacking, Multiple Dimensions

jfredericks — Tue, 23 Feb 2021 15:34:27 GMT

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?

Re: Text on Axis stacking, Multiple Dimensions

jfredericks — Fri, 19 Mar 2021 21:01:56 GMT

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.