topic Re: Currency Symbol on Y axis in QlikView

Currency Symbol on Y axis

Anonymous — Fri, 06 May 2016 02:39:02 GMT

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,

Re: Currency Symbol on Y axis

sunny_talwar — Fri, 06 May 2016 15:11:31 GMT

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

Re: Currency Symbol on Y axis

Anonymous — Fri, 06 May 2016 18:55:51 GMT

Hi Sunny,

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

Let me know if you find something else.

Regards,

Re: Currency Symbol on Y axis

sunny_talwar — Fri, 06 May 2016 19:09:00 GMT

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

Peter_Cammaert — Fri, 06 May 2016 19:17:50 GMT

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

sunny_talwar — Fri, 06 May 2016 19:21:57 GMT

Check this out:

Currency and Other Symbols on the Y-Axis | Qlikview Cookbook

Re: Currency Symbol on Y axis

trdandamudi — Fri, 06 May 2016 19:28:27 GMT

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.

Re: Currency Symbol on Y axis

Anonymous — Mon, 09 May 2016 16:18:31 GMT

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,

Re: Currency Symbol on Y axis

Anonymous — Mon, 09 May 2016 16:19:04 GMT

Hi Sunny,

Any other way you have implemented.

Regards,

Re: Currency Symbol on Y axis

sunny_talwar — Mon, 09 May 2016 16:36:49 GMT

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

Re: Currency Symbol on Y axis

Anonymous — Thu, 12 May 2016 15:18:13 GMT

Hi Sunny,

I am trying to implement it not able to figure it out but working on the same path you suggested.

Thanks.

Regards,

Re: Currency Symbol on Y axis

kkkumar82 — Wed, 23 May 2018 16:14:48 GMT

Hi sunny,

I have a similar situation now where I want $ for Y axis values but as per now my max value is 800000 but it can also go upto 5000

my idea was to break the Y axis values to a minimum 5 sets like if the value is 4500 I would like to have

1000,2000,3000,4000 and 5000 and for my current value as it is 800000 I would like to show up

200000, 400000,........1000000

I started writing the if conditions in my "Step value" property but ended upto a lot like below,

any simplified idea so that the graphs should give me atleast five steps irrespective of my max value

if(Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5<10000,

Round(

Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5,2000),

if(Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5<20000,

Round(

Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5,4000),

if(Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5<30000,

Round(

Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5,5000),

if(Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5<40000,

Round(

Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5,6000),

if(Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5<50000,

Round(

Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5,10000),

if(Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5<100000,

Round(

Max(Total Aggr(Rangesum(Above(sum({$<PlanVersion= {'$(vMaxPlan)'}>}[Amount_FCST]/Factor),0,RowNo())),ForecastFormula.DaysinQuarter))/5,20000)

))))))