topic Re: Trying to build a If Statement in QlikView

Trying to build a If Statement

Anonymous — Wed, 19 Aug 2015 18:13:20 GMT

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 — Wed, 19 Aug 2015 18:41:35 GMT

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

sunny_talwar — Wed, 19 Aug 2015 18:47:59 GMT

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

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 — Wed, 19 Aug 2015 18:56:11 GMT

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

qlikviewwizard — Thu, 20 Aug 2015 02:35:20 GMT

Hi Use this:

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

Anonymous — Thu, 20 Aug 2015 11:16:32 GMT

Thanks Look like that worked

Tom

qlikviewwizard — Thu, 20 Aug 2015 14:22:07 GMT

Hi Tom,

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