topic Re: Two dimensional chart total values in QlikView

Two dimensional chart total values

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

Hello everybody,

I need help concerning chart, specifically its total column. The case is the following:

I have two dimensions - quarter and year and I have expression sum(value). I have ticked the 'show total' for quarter in "Dimension Limits" tab, but what I am getting is one total column. I need to have different TOTAL columns for different years. The picture below represents what I am getting now. Is it possible to have separate totals for different years?

Thank you very much in advance for your help.

Re: Two dimensional chart total values

vishalgoud — Mon, 12 Mar 2018 16:57:57 GMT

If you want to show year wise total, i think you can go with Pivot table, in bar chart it will show to total for your entire dimension.

Re: Two dimensional chart total values

isingh30 — Mon, 12 Mar 2018 19:15:00 GMT

Use trellis chart. You can compare between multiple years as well.

Re: Two dimensional chart total values

Nagaraju_KCS — Tue, 13 Mar 2018 05:16:35 GMT

Hope it helps...!

Re: Two dimensional chart total values

tbakhtadze — Wed, 14 Mar 2018 07:48:52 GMT

Thank you so much to all of you for your replies. They were very helpful for me as I am new to qlikview.

Raju, thanks for sharing your .qvw file. I wanted to have TOTALS at the end of the chart, not after each quarter, that's why I have modified it slightly (I deleted total from expressions and ticked the show total for quarter) and now it is exactly what I wanted. Thank you once again!