$ Sign in Y axis not always working

[mhmmd_srf]

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

[jonathandienst]

I cant replicate your problem in the example you posted.

[tresesco]

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.

[mhmmd_srf]

Hi Jonty,

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

Please check and advise.

Thanks,

Sarif

[mhmmd_srf]

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

[tresesco · Accepted solution]

Hi Sarif,

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

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

[mhmmd_srf]

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