Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
pjaishiv
New Contributor

Custom formatting Symbols for Y-axis values

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

6 Replies
Employee
Employee

Re: Custom formatting Symbols for Y-axis values

Are you using a combo chart ?

balabhaskarqlik
Honored Contributor

Re: Custom formatting Symbols for Y-axis values

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

change the continuous to custom.

Highlighted
pjaishiv
New Contributor

Re: Custom formatting Symbols for Y-axis values

No. Just the Line chart

Partner
Partner

Re: Custom formatting Symbols for Y-axis values

share sample .qvw and expected result.

Employee
Employee

Re: Custom formatting Symbols for Y-axis values

Try converting to a combo chart

balabhaskarqlik
Honored Contributor

Re: Custom formatting Symbols for Y-axis values

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