Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tbakhtadze
New Contributor

Two dimensional chart total values

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.


chart.jpg

1 Solution

Accepted Solutions
qv_testing
Valued Contributor II

Re: Two dimensional chart total values

Hope it helps...!

View solution in original post

4 Replies
vishalgoud
Contributor III

Re: Two dimensional chart total values

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.

isingh30
Valued Contributor

Re: Two dimensional chart total values

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

qv_testing
Valued Contributor II

Re: Two dimensional chart total values

Hope it helps...!

View solution in original post

tbakhtadze
New Contributor

Re: Two dimensional chart total values

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!TOTAL.jpg