topic Re: How do i replace text in a field as Null in QlikView

How do i replace text in a field as Null

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How do i replace text in a field as Null

Name

John

N/A

Paul

I want to change the 'N/A's in Name field to NULLS.

Thanks

marcus_sommer — Mon, 16 Jan 2017 13:13:03 GMT

Try: if(Name = 'N/A', null(), Name) as Name

- Marcus

avinashelite — Mon, 16 Jan 2017 13:13:34 GMT

//in front end

If(Name='N/A','',Name)

//in backend

If(Name='N/A','',Name) as Name

Anonymous — Mon, 16 Jan 2017 13:15:47 GMT

Thanks

ARHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!

I was missing the '()' on null()

Thanks.