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: 
Ehumphree
Contributor
Contributor

How to separate data

Hi Everyone,

I am trying to split a data set that is displayed in one column into two separate columns in a table.

i.e. LW_FLAG 1 = In Time and 2 = Long Wait.

I want to be able to show these in two separate columns. 

Speciality In Time on Wait ListLong Wait on Wait List
Category   

Any assistance you can provide will be greatly appreciated.

 

 

 

1 Reply
NJC
Contributor
Contributor

Hi @Ehumphree ,

Try like below in load editor 

if(LW_FLAG=1,'In Time','NA') as [In Time on Wait List],
if(LW_FLAG=2,'Long Wait','NA') as [Long Wait on Wait List]

Thanks!