topic $ Sign in Y axis not always working in QlikView

$ Sign in Y axis not always working

mhmmd_srf — Tue, 26 Mar 2019 08:22:17 GMT

Hi All,

Greetings for the day.

I have a combo chart showing Sales and Units by Period. I need to show $ sign in Y axis. I handled this using Static Step, but this is not working always. For some Items, qlik is showing the $ sign , for some items it is not. I understand this is due to huge range of value.

As an example:

for Item No 002121 - $ sign not showing

for Item No 054101 - $ sign is showing

Could you please check and advise.

I am attaching the qvw file here.

Thanks,

Sarif

Re: $ Sign in Y axis not always working

jonathandienst — Tue, 26 Mar 2019 08:42:29 GMT

I cant replicate your problem in the example you posted.

Re: $ Sign in Y axis not always working

tresB — Tue, 26 Mar 2019 08:55:52 GMT

When you are using static step, the chart would not show the symbols unless all the values are adjusted and shown in the axis. Try to pull and make your chart taller, when you see that all the possible values (as per static step and your data) have come up, you would also be able to see the symbols at the same time.

Re: $ Sign in Y axis not always working

mhmmd_srf — Tue, 26 Mar 2019 09:15:35 GMT

Hi Jonty,

I am attaching one word doc with screen shot, hope this will help you.

Please check and advise.

Thanks,

Sarif

Re: $ Sign in Y axis not always working

mhmmd_srf — Tue, 26 Mar 2019 09:17:39 GMT

Hi TB,

I already tried this approach, but no luck.

For few Items Y axis is showing $ sign and for few it is not.

Is it possible to try once from your end.

Thanks,

Sarif

Re: $ Sign in Y axis not always working

tresB — Tue, 26 Mar 2019 09:39:42 GMT

Hi Sarif,

Instead of using 1 as static step value, try using exp like:

Round(Max(Aggr(Sum(Sales), CstMonthNameAbbr))/10,10)

Re: $ Sign in Y axis not always working

mhmmd_srf — Wed, 27 Mar 2019 08:05:09 GMT

Hello TB,

Thank you so much for your quick help.

I implemented the solution you provided. It looks much better, but not working always.

If you select Item No = 005201, it is not showing any Dollar sign.

I tried various other combination in the expression you provided. But no luck.

Please help.

Thanks,

Sarif