Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rahulgaadhe
New Contributor II

Currency Symbol on Y axis

Dear Experts,

I am trying to implement a bar chart to have currency symbol for example "$" sign on every Y axis step.

Please suggest how I can achieve above mentioned functionality.

I tried using "Symbol" options on number tab of bar chart but it gives symbols only at top of Y axis(screenshot attached) but not on every step.

Any help in this regard is highly appreciated.

Regards,

RG

Tags (2)
11 Replies

Re: Currency Symbol on Y axis

May be use Num() function like this -> Num(Expression, '$#,##0.') and use expression default on the number tab

rahulgaadhe
New Contributor II

Re: Currency Symbol on Y axis

Hi Sunny,

I implemented the way you suggested but no change in the output.

Let me know if you find something else.

Regards,

RG

Re: Currency Symbol on Y axis

Would you be able to share a sample? In the mean time I will try it out on my end

Re: Currency Symbol on Y axis

AFAIK there is no separate formatting for Y-axis labels. You can however put a currency symbol at the top of the axis by filling in the Symbol, Thousand Symbol, Million Symbol fields on the Chart Properties->Number tab.

Peter

Re: Currency Symbol on Y axis

trdandamudi
Honored Contributor

Re: Currency Symbol on Y axis

Add a value to the "Static Step" (in the Axis tab)  and you will see the $ sign for every value on the Y-axis. It is little weird I hope it is not a bug but it works.

rahulgaadhe
New Contributor II

Re: Currency Symbol on Y axis

Hi Thirumala,

It works but in my case the chart is for amount which is in millions, thousands and hundreds.When we give static small value for step like 5 it works for millions but when I do some selections and the value comes in thousands and in that case it does not show the $ sign.

Any other way you have implemented.

Regards,

RG

rahulgaadhe
New Contributor II

Re: Currency Symbol on Y axis

Hi Sunny,

It works but in my case the chart is for amount which is in millions, thousands and hundreds.When we give static small value for step like 5 it works for millions but when I do some selections and the value comes in thousands and in that case it does not show the $ sign.

Any other way you have implemented.

Regards,

RG

Re: Currency Symbol on Y axis

For static step use a calculation such as Max(Value)/5 or something similar so that the static steps changes based on selection. For the exact expression, you will have to play around with it to get something which might look reasonable

Community Browser