Bar chart Properties - Totals and change axis

[brunopaulo]

Hi community,

I'm facing a issue that i can't solve or finding a turn around.

I have this bar chart:

I want to add totals for the end of year. If i go to Properties ---> Dimensions limits-----> in 'Options' block and mark Show Total it gives me the expected result. The trick is, i want to display the total in right y axe. Anyone has any idea how to go turn around this?

Thanks in advance.

Best Regards

Bruno Paulo

[jonathandienst]

On the Axis tab, select the expression and check the Right (Top) option in the Position section.

[brunopaulo]

I have 2 expressions and i want the sum of all months in a single colum called Total.

So if i change the axis wont give me the result that i expect. On top of that, When i go to dimensions limit and mark the total there isn't a expression to do what you suggest.

Maybe i'm not making myself clear. So please see the image below.

I want this but with the Total on right axis. I got this graph selecting show total in dimensions limit menu.

Anymore idea?

Thanks anyway.

Bruno

[raman_rastogi]

These are sample thread which might be use full for you.

Bar Chart One Sum Dimension and add Average Dim... | Qlik Community

how to show total bar as first bar in bar chart in qlikview

Subtotals and multiple dimensions in a barchart

[brunopaulo · Accepted solution]

If anyone has this problem, the solution is get 2 objects and use white text boxes in order to fill the gaps because they cant have same size in order to get same width on the bars. And use transparency (Colors menu) and position 1 of them in bottom (layer menu). Isn't absolutely perfect but it was the best i can. Maybe with some more efford u can a bit

more.

Best Regards

Bruno