# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## If statement help

I'm trying to create a new measure using the following if statement, however not working help please.

if {[Ext Transaction Code]="326"} then

Sum([LAS Principal])-Sum([Charged Off Amount]);

else

Sum([LAS Principal]);
end if

Tags (3)
1 Solution

Accepted Solutions
MVP

## Re: If statement help

Try this may be:

If([Ext Transaction Code] = 326, Sum([LAS Principal]) - Sum([Charged Off Amount]), Sum([LAS Principal]))

4 Replies
MVP

## Re: If statement help

Try this may be:

If([Ext Transaction Code] = 326, Sum([LAS Principal]) - Sum([Charged Off Amount]), Sum([LAS Principal]))

MVP

## Re: If statement help

Hi Mark, there are two kind of 'if', you're using the syntasx that controls wich section of the script runs, meanwhile the logic of your 'if' leads to a condition to check the loaded values, in this case the syntax is inside the load sentence:

If([Ext Transaction Code]=326, Sum([LAS Principal])-Sum([Charged Off Amount]), Sum([LAS Principal])) as LAS

//If(Condition, thenSentences, elseSentences) as NameOfResultingField

Btw, if you're using a Sum() inside the load you'll need to use the 'group by' clause.

New Contributor III

## Re: If statement help

Can you explain what you mean and what is the "group cause", please? Thanks!

MVP

## Re: If statement help

If you have aggregation functions like Sum(), Avg()... some function that makes a calculation over different records you'll neded to set aggroup by by all other fields that aren't in an aggregation function: