Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

total column

Total as the result of 2 columns

Sem título.png

tks

4 Replies
julian_rodrigue
Not applicable

Re: total column

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

Not applicable

Re: total column

Hi there,

You can just add the 2 columns by this:

Column(5) + Column(6)

greetings, Dave

khadeer_sparks
Not applicable

Re: total column

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.

rwunderlich
Not applicable

Re: total column

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