how to display the bar chart axis negative values in to brackets ()

[venkatbza]

Hi Friends,

I have a question i would like to show bar chart axis negative values in to (). and i tried to use like this in the expression but not no luck #.##0,00; (#.##0,00)

any one help me resolve this issue.

below the example image.

[sunny_talwar]

See if this approach helps:

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

[krishnacbe]

You can set using two steps

1. Assign the Number Format #,##0; (#,##0)

2. Add the values in Static Step for example 10 for my example attached

Hope the attached file helps

[venkatbza]

Hi Krishnapriya,

As per your example if i take static step as 3 it is not showing in brackets it is showing -20

[krishnacbe · Accepted solution]

Expand the chart and give the Static step as 3, it is showing up as expected.

[venkatbza]

Thanks, it is working

[venkatbza]

Hi,

Is there any dynamic way to do this instead of expanding the chart every time.

[krishnacbe]

Try enabling the X- Axis Scroll bar and check. in Presentation Tab.