# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor III

## sum + case

hi,

I would make the sum of two fields conditioned by another value
example :
case white

sum(1+10):

case red

sum(2+20)

else

sum(3+20)

11 Replies
Honored Contributor II

## Re: sum + case

You would use an IF statement for this in Qlik.

Either on load to create a new value or in the measure as an expression assuming white and red are dimension values.

.

.

If([Field] = White, sum(1+10), If([Field] = Red, sum(2+20), sum(3+30), 0))) As New Field

MVP

## Re: sum + case

You can also combine WildMatch and Pick:

Pick( WildMatch( Color , 'white' , 'red' , '*' )

Sum( 1 + 10 )

, Sum( 2 + 20 )

, Sum( 3 + 20 )

)

MVP

## Re: sum + case

Hi,

If you have many Cases then best approach is to use Pick() and WildMatch() like below

Pick(WildMatch(FieldName, 'white', 'red', '*'),

Sum(1+10),

Sum(2+20),

Sum(3+20))

Hope this helps you.

Regards,

Jagan.

Contributor III

## Re: sum + case

hi,

could I apply this formula at a total?

MVP

## Re: sum + case

Hi,

Where you want to get the total?  If it is straight table select

Properties-> Expression-> Sum of Rows

Hope this helps you.

Regards,

Jagan.

Honored Contributor II

## Re: sum + case

It is better not to use IF statement for better performance. IF will consume more resources.

Thank you.

Contributor III

## Re: sum + case

hi,

excuse me, It wasn't clear.

I need.

sum everything except field = VALUE

Honored Contributor III

## Re: sum + case

May be try

If([Field] = 'Value',0,if([Field] = 'White', sum(1+10), If([Field] = 'Red', sum(2+20), sum(3+30)))

Honored Contributor II