topic Re: total column in QlikView

total column

Wed, 27 Feb 2013 19:38:00 GMT

Total as the result of 2 columns

tks

Re: total column

julian_rodriguez — Wed, 27 Feb 2013 20:05:19 GMT

What is the expression on each column?

If you are using, for example Sum([Sales]) on Column(1) and Sum([Budget]) on Colum(2), your third expression should be like: Sum(Total [Sales]) - Sum(Total [Budget]).

Regards

Re: total column

Wed, 27 Feb 2013 22:41:39 GMT

Hi there,

You can just add the 2 columns by this:

Column(5) + Column(6)

greetings, Dave

Re: total column

khadeer — Thu, 28 Feb 2013 04:01:44 GMT

Hi Rocha,

U can use Coloumn(6)-Coloumn(5)

else

if ur Coloumn(6) expression is named(Name of expression) as Budget and similarly Coloumn(5) as Actual.

if u want to show Budget - Actual

u can use [Budget]-[Actual]

both will give you the same result.

PFA for reference.

Re: total column

rwunderlich — Thu, 28 Feb 2013 04:39:57 GMT

You are missing a closing paren. But as others have pointed out, the correct syntax is

column(6) - column(5)

No need to incluude sum() function.

-Rob