Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if condition issue in qlikview

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 

3 Replies
Not applicable
Author

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

tresesco
MVP
MVP

May be like:

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

PrashantSangle

Hi,

Like this

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂