Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshbaabu
Contributor III

Calculated Dimension - TOTAL

Hello All,

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?

Thank you.

1 Solution

Accepted Solutions
Not applicable

Re: Calculated Dimension - TOTAL

in dimension limit

check total mode

see attachement

5 Replies
Not applicable

Re: Calculated Dimension - TOTAL

write this in your expression

dimension= Region

expression=sum(scores)

and in dimension limit--   check the total sum

see attachement

Not applicable

Re: Calculated Dimension - TOTAL

in dimension limit

check total mode

see attachement

sureshbaabu
Contributor III

Re: Calculated Dimension - TOTAL

Hello Vishwa,


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

prasad_dumbre
Contributor

Re: Calculated Dimension - TOTAL

Hi,

Just remove Total from expression in vishwaranjan's application, else its perfect for your req.

sureshbaabu
Contributor III

Re: Calculated Dimension - TOTAL

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?

Thanks

Community Browser