Discussion Board for collaboration on QlikView Layout & Visualizations.
I need your help with the request below.
Source Columns : Region , Scores
Values for Region Column: North, South, East, West
I wanted to plot a bar chart to count the Scores on each region.
My dimension : Region
My expression: Sum(Scores)
Default Display is:
X axis -> 4 bars (one for North, one for South, one for East, one for West)
Y axis -> Sum of the Scores
Requirement: I want to have 5 Bar’s in the X axis, which shows the TOTAL of all 4 regions. That will be my 5th BAR of X Axis
Could you please help me in achieving this?
Go to Solution.
in dimension limit
check total mode
write this in your expression
and in dimension limit-- check the total sum
Awesome.Thanks a Lot.
I normally do that for table views whenever required. But never realized that we can do it for Graphs.
It worked. Thanks again
Just remove Total from expression in vishwaranjan's application, else its perfect for your req.
Yeah!!! Can we sort dimension for the Total Column?
I'm aware that we can write the expression on Sort tab or to pull a column for sorting.
But, Can we move the TOTAL column to the first position in the above senario?