Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Split one field into whole new field with If condition

Hello Guys,

I want to split Status Field into something as mentioned below :-

I need to put If condition and create a new field such as

If (Status'Anticipated', Status='Quote Submitted' , Status='No Quote') = Progress

If (Status='Lost', Status='WIN in Flow 3', Status='Canceled') = Win    as [Status Type]

I want to club this 2 If condition and create new field [Status Type]

Could you please tell me how do we do this ?

Thanks,

ravi

1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Hi,

After Reloading the Table [Status Type] willbe created so you can't use [Status Type] in the same Table where condition.


you can try something like this.


FROM [Project.qvd]

(qvd)

Where Match(Status,'Anticipated','Quote Submitted','No Quote');

View solution in original post

8 Replies
shraddha_g
Partner - Master III
Partner - Master III

If (Wildmatch(Status,'Anticipated', 'Quote Submitted' ,'No Quote'),'Progress',

If (Wildmatch(Status,'Lost', 'WIN in Flow 3', 'Canceled') ,'Win'  ))  as [Status Type]

mdmukramali
Specialist III
Specialist III

Hi,

you can use match function,

If(Match(Status,'Anticipated','Quote Submitted','No Quote'),'Progress',

     if(Match(Status,Lost','WIN in Flow 3','Canceled'),'WIN')) as [Status Type]


arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Ravi,

It may be like this:

If (Wildmatch(Status,'Anticipated', 'Quote Submitted' , 'No Quote') , 'Progress'

      If (Wildmatch(Status,'Lost', WIN in Flow 3', 'Canceled') ,'Win'))            as [Status Type]


Thanks,

Arvind Patil

Anonymous
Not applicable
Author

Thanks a lot It worked

Anonymous
Not applicable
Author

Thanks arvind_patil , mdmukramali  It worked

Anonymous
Not applicable
Author

Guys ,

Now if i want to use only the  Progress option . i am doing something like this :-

FROM [Project.qvd]

(qvd)

Where ( [Status Type]='Progress');

but if i do this it says [Status Type] not found , So how do i use only 'Progress' status ?

Thanks,

ravi

mdmukramali
Specialist III
Specialist III

Hi,

After Reloading the Table [Status Type] willbe created so you can't use [Status Type] in the same Table where condition.


you can try something like this.


FROM [Project.qvd]

(qvd)

Where Match(Status,'Anticipated','Quote Submitted','No Quote');

Anonymous
Not applicable
Author

Thank you mdmukramali