topic Re: IF with missing ELSE values in QlikView

IF with missing ELSE values

Anonymous — Tue, 25 Jun 2013 15:31:28 GMT

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.

Re: IF with missing ELSE values

Gysbert_Wassenaar — Tue, 25 Jun 2013 16:12:19 GMT

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

Re: IF with missing ELSE values

Anonymous — Tue, 25 Jun 2013 16:33:20 GMT

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