Trying to build a If Statement

[Anonymous]

I am trying to build a if statement from 2 fields in the same table and load back to the table so I can use in reports I am creating

if([Claim_Type]='Lost Time',if([Claim_Status]='Open',1,0))as LT Open

[swuehl]

what issues do you see? Could you post some sample data lines of that table and your requested result?

[sunny_talwar]

Whatis the logic you are trying to follow here?? May be this:

If you are trying to flag LT Open with 1 when both Claim Type is Lost Time and Claim Status is Open

if([Claim_Type]='Lost Time' and [Claim_Status]='Open',1,0) as LT Open

or

If you are trying to flag LT Open with 1 when both Claim Type is Lost Time or Claim Status is Open

if([Claim_Type]='Lost Time' or[Claim_Status]='Open',1,0) as LT Open

[sasiparupudi1]

if([Claim_Type]='Lost Time' and [Claim_Status]='Open',1,0) as LT Open

[qlikviewwizard]

Hi Use this:

if(([Claim_Type]='Lost Time' and [Claim_Status]='Open'),1,0) as [LT Open],

[Anonymous]

Thanks Look like that worked

Tom

[qlikviewwizard]

Hi Tom,

Please close the thread by selecting Correct Answer,Helpful answers and Close the thread. Thank you