topic Re: Calculated Dimension - TOTAL in QlikView

Calculated Dimension - TOTAL

sureshbaabu — Wed, 03 Jul 2013 10:58:30 GMT

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.

Wed, 03 Jul 2013 11:08:50 GMT

write this in your expression

dimension= Region

expression=sum(scores)

and in dimension limit-- check the total sum

see attachement

Wed, 03 Jul 2013 11:11:19 GMT

in dimension limit

check total mode

see attachement

sureshbaabu — Wed, 03 Jul 2013 11:18:20 GMT

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 — Wed, 03 Jul 2013 11:23:22 GMT

Hi,

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

sureshbaabu — Wed, 03 Jul 2013 11:30:27 GMT

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