Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
mapratt82
Creator
Creator

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   

1 Solution

Accepted Solutions
sunny_talwar

Try this may be:

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

View solution in original post

4 Replies
sunny_talwar

Try this may be:

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

rubenmarin

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:

LOAD YourFields,

     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.

mapratt82
Creator
Creator
Author

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

rubenmarin

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:

LOAD YourFields,

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

Group by Yourfields, [Ext Transaction Code];

But maybe you only need to remove the sum():

LOAD YourFields,

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

...