topic Re: Display chart axis negative values as () in QlikView

Display chart axis negative values as ()

Mon, 11 Jul 2016 06:27:56 GMT

I have a bar chart but I want to display the Axis with () as negative values. I have changed the number format property but that only affects the pop-up value.

Any suggestions? Also is there a way (without /1000000) to display the pop-up in the same number format ($m) as the chart. This is a very inconsistent format for the data. Users can drill down to a very detailed level so hard coding millions is not the right solution.

Re: Display chart axis negative values as ()

Anonymous — Mon, 11 Jul 2016 08:21:09 GMT

On the Number tab of the properties screen select your expression and check Fixed to under Number Format Settings. Set the format pattern to #.##0,00; (#.##0,00)

Re: Display chart axis negative values as ()

Mon, 11 Jul 2016 22:15:14 GMT

Hi. I have tried this but it does not change the Axis values to be in brackets only the values on the popups. The screenshot has your formatting already applied.

Re: Display chart axis negative values as ()

vardhancse — Tue, 12 Jul 2016 03:48:57 GMT

In the chart expression say for eg Sum(Sale)

include number format as

Num(Sum(Sales),#.##0,00; (#.##0,00))