topic Re: replacing zero with null values in QlikView

replacing zero with null values

ssriramin19 — Wed, 13 Nov 2013 08:16:11 GMT

Hello

I have a field which contains the zero values and null values. I need to replace both null to zero and zero to null. Is this possible.

Thanks

Sriram

Re: replacing zero with null values

kaushiknsolanki — Wed, 13 Nov 2013 08:18:06 GMT

HI,

Try this way.

Load

if(isnull(Field1),0,Field1) as Field1,

if(Field2 = 0, null(),Field2) as Field2

From xyz;

Regards,

Kaushik Solanki

Re: replacing zero with null values

ssriramin19 — Wed, 13 Nov 2013 08:22:54 GMT

is it not possible to write the expression in the front end itself.Also both field 1 and field 2 si same field . There is only field which changes needs to be done...

Thanks

Sriram

Re: replacing zero with null values

kaushiknsolanki — Wed, 13 Nov 2013 08:24:49 GMT

Hi,

Yes this expressions are for script only.

Why dont you change that in script.

Regards,

Kaushik Solanki

Re: replacing zero with null values

ssriramin19 — Wed, 13 Nov 2013 08:26:55 GMT

In my case both field 1 and field 2 refers to same field .Whether this can be done.?

Thanks

Sriram

Re: replacing zero with null values

kaushiknsolanki — Wed, 13 Nov 2013 08:29:04 GMT

Hi,

Yes you can do it, even though they are same field.

Regards,

Kaushik Solanki

Re: replacing zero with null values

Wed, 13 Nov 2013 08:42:13 GMT

Hi,

Kaushik.solanki shows clearly indicate the solution. Therefore u can use the following to solve your problem.

Load

if(isnull(Field1),0, if(Field1=0,null(),Field1) as Field1

From xyz;

Regards

Re: replacing zero with null values

ssriramin19 — Wed, 13 Nov 2013 09:08:15 GMT

Thanks very much...