topic inlist in if then else in QlikView

inlist in if then else

Fri, 12 Feb 2016 13:44:49 GMT

Hi Friends,

I have posted a query which was half answered about the date ranges, and since that was not possible with Set Analysis I have made the following query which works fine.

if(

(($(vSysDate)>= $(vDropDeadMonth))

AND ($(vSysDate)<= $(vDropDeadDate))

AND (Status=('Pre Approved')

OR Status=('Approved'))

AND (Outcome=('Funded')

OR Outcome=('Funded')

OR Outcome=('Funded'))

)

(($(vSysDate)>= $(vDropDeadLastWk))

AND ($(vSysDate)<= $(vDropDeadDate))

AND (Status=('Pre Approved')

OR Status=('Approved'))

AND (Outcome=('Funded')

OR Outcome=('Funded')

OR Outcome=('Funded'))

)

,'Yes','No'

)

As you can see for both the Status and Outcome , if we have something like InList it would be great , please suggets.

Ex:Status InList('Approved','Pre Approved')

Re: inlist in if then else

petter — Fri, 12 Feb 2016 18:23:48 GMT

You can use Match do check against a list of text strings:

Match( Status , 'Approved' , 'Pre Approved' , ..... ) > 0

Actually just

Match( Status , 'Approved' , 'Pre Approved' , ..... )

Will leave you with the right test since you get a positive number if there is a match and 0 if not. Any non zero return will be interpreted as true and zero will be false.

Re: inlist in if then else

Mon, 15 Feb 2016 10:35:52 GMT

Thanks Petter, it was helpful

if(

(($(vSysDate)>= $(vDropDeadMonth))

AND ($(vSysDate)<= $(vDropDeadDate))

AND Match( Status , 'Approved' , 'Pre Approved')

AND (Outcome=('Funded')

OR Outcome=('Phased Funded')

OR Outcome=('Conditionally Funded')

OR Outcome=('Partially Funded'))

)

(($(vSysDate)>= $(vDropDeadLastWk))

AND ($(vSysDate)<= $(vDropDeadDate))

AND Match( Status , 'Approved' , 'Pre Approved')

AND Match( Outcome , 'Funded' , 'Phased Funded','Conditionally Funded','Partially Funded')

)

,'Yes','No'

)