topic Re: Custom formatting Symbols for Y-axis values in QlikView

Custom formatting Symbols for Y-axis values

Anonymous — Mon, 16 Jul 2018 11:25:46 GMT

Hi,

Is there a way to custom format the Y-Axis symbol (prefixed/suffixed to the values)?

Currently I have two similar type of metrics (with different units) to be displayed in the same line chart object.

Metric1 is in $ value
Metric2 is in % value

The input for metric selection is through a button click which is linked to set a variable value. I have correspondingly coded the Line chart expression based on the variable value and formatted the metric values using Num() function.

However, I'm not getting the $ and % symbol for each value on Y-axis. Is there any solution for this? Or am I missing anything?

Number Format Settings in Number tab is set to Expression default and I need the symbols for each values on Y-axis, so the Symbol option inside Number tab is not helpful.

PS: The formatting works if I have them in two separate line charts. The issue is only when I try to combine both the metrics in a single chart.

Thanks,

Shiva

Re: Custom formatting Symbols for Y-axis values

Lisa_P — Tue, 17 Jul 2018 01:25:14 GMT

Are you using a combo chart ?

Re: Custom formatting Symbols for Y-axis values

BalaBhaskar_Qlik — Tue, 17 Jul 2018 12:52:39 GMT

May be, in the chart properties -> axes -> Dimension Axis -

change the continuous to custom.

Re: Custom formatting Symbols for Y-axis values

Anonymous — Thu, 19 Jul 2018 13:46:59 GMT

No. Just the Line chart

Re: Custom formatting Symbols for Y-axis values

raviityou — Fri, 27 Jul 2018 08:28:53 GMT

share sample .qvw and expected result.

Re: Custom formatting Symbols for Y-axis values

Lisa_P — Tue, 31 Jul 2018 02:21:02 GMT

Try converting to a combo chart

Re: Custom formatting Symbols for Y-axis values

BalaBhaskar_Qlik — Tue, 31 Jul 2018 07:29:21 GMT

Did you got the solution, share it to others to resolve their issues.