topic Re: Total 3 Columns in QlikView

Total 3 Columns

mwscott1 — Wed, 11 Nov 2015 15:01:57 GMT

I have two tables both joined by column REF Number. I need to know how to total the other three columns

Table 1

REF Number	Candidate Submitted
R0001	1

Table 2

Candidate Submitted + Interview Scheduled + Candidate Appointed = 16

sunny_talwar — Wed, 11 Nov 2015 15:12:25 GMT

May be use RangeSum() function

RangeSum(Sum([Candidate Submitted]), Sum([Interview Scheduled]), Sum([Candidate Appointed]))

mwscott1 — Wed, 11 Nov 2015 16:00:04 GMT

Is it possible to include this in the load so that it loads a "Total"

sunny_talwar — Wed, 11 Nov 2015 16:38:56 GMT

In the load you can do this:

RangeSum([Candidate Submitted], [Interview Scheduled], [Candidate Appointed]) as SumOfThreeFields