topic Re: if condition and not using match function to combine the fields in QlikView

if condition and not using match function to combine the fields

Sat, 20 Sep 2014 11:05:33 GMT

Hi all,

I have some data

status close_flag

closed -1

>closed -1

closed-app -1

cancelled -1

open 0

completed 0

if(close_flag = -1,if((wild match('closed', '>closed', 'closed-app', 'cancelled'),'closed', status),status) I am using this condition to merge the all closed fields (close_ flag = -1) into one common field is closed. this is the hardcoded code . only this close_flag = -1 is correct the field merge to the closed field how to merge without using wild match, match functions .

is it possible plz tell me......urgent

Re: if condition and not using match function to combine the fields

MK_QSL — Sat, 20 Sep 2014 12:29:10 GMT

IF(close_flag = -1, 'Close',status) as status

Re: if condition and not using match function to combine the fields

MarcoWedel — Sat, 20 Sep 2014 12:44:55 GMT

if(close_flag,'closed',status) as Closed

Re: if condition and not using match function to combine the fields

MarcoWedel — Sat, 20 Sep 2014 13:59:17 GMT

plz close thread......urgent

thanks

regards

Marco