topic Re: if condition issue in qlikview in QlikView

if condition issue in qlikview

Fri, 19 Sep 2014 11:15:28 GMT

status close_flag

closed -1
>closed -1

closed-opp -1
open 0

completed 0

if(close_flag= -1,if( (match('closed','>closed', 'closed-opp' ),'closed', status),status

in the expression if close_flag equal to -1 then combined the all closed values( into closed filed other wise it display the remaining values. the expression plz correct or not other wise plz tell me and write correct expression urgent......plz any one

Re: if condition issue in qlikview

Fri, 19 Sep 2014 11:16:23 GMT

the expression is not working plz tell me ....

Re: if condition issue in qlikview

tresB — Fri, 19 Sep 2014 11:18:00 GMT

May be like:

......(match(status, 'closed','>closed',

Re: if condition issue in qlikview

PrashantSangle — Fri, 19 Sep 2014 11:21:22 GMT

Hi,

Like this

if(close_flag= -1,if( wildmatch(status,'closed','>closed', 'closed-opp' ),'closed', status))

Regards