topic Re: Bar chart Properties - Totals and change axis in QlikView

Bar chart Properties - Totals and change axis

brunopaulo — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Bar chart Properties - Totals and change axis

jonathandienst — Wed, 26 Sep 2018 10:55:07 GMT

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

Re: Bar chart Properties - Totals and change axis

brunopaulo — Wed, 26 Sep 2018 11:18:52 GMT

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

Re: Bar chart Properties - Totals and change axis

raman_rastogi — Wed, 26 Sep 2018 12:08:40 GMT

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

Re: Bar chart Properties - Totals and change axis

brunopaulo — Wed, 26 Sep 2018 15:02:21 GMT

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