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

IF with missing ELSE values

Hi,

I want to use the IF in the script to replace certain values before a set period and keep the rest of the values before and after the period.

The IF below only keeps the new values.I have attached a spreadsheet with examples of the values before and after the IF that I need in the result.

if([Disposition Date] < '07/13/20013',

if([Disposition Description] = 'NEW', 'LOADED',

if([Disposition Description] = 'Intent To Apply', 'Accepted, No App',))

      ,[Disposition Description] ) as [Disposition Description],

Thank you.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try: if([Disposition Date] >= '07/13/20013',[Disposition Date], replace(replace([Disposition Date],'NEW','LOADED'),'Intent To Apply','Accepted, No App')) as [Disposition Date]


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try: if([Disposition Date] >= '07/13/20013',[Disposition Date], replace(replace([Disposition Date],'NEW','LOADED'),'Intent To Apply','Accepted, No App')) as [Disposition Date]


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Great it worked when I changed the field name and use your suggestion.

Thank you!

if([Disposition Date] >= '07/13/20013',[Disposition Description], replace(replace([Disposition Description],'NEW','LOADED'),'Intent To Apply','Accepted, No App')) as [Disposition Description] ,