Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
emb_2012
New Contributor

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

Re: IF with missing ELSE values

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
2 Replies

Re: IF with missing ELSE values

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
emb_2012
New Contributor

Re: IF with missing ELSE values

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] ,

Community Browser