flag identifiers

[#1]

I have a requirement like :

suppose one field as x  for yes nd no it shud polulate 1

and for null values it should polulate as 0

[sunny_talwar]

May be like this

If(Len(Trim(x)) = 0, 0, 1) as Flag

[#3]

so in the above how it will polulate 0 for null(-) values

[#4]

so currently i have written as

if(x='','0','1')

[sunny_talwar]

Len(Trim()) will check for the Nulls

[#6]

it will check fr null values,

but how it will polulate 0 in thse null values

[sunny_talwar]

If Len(Trim(x)) is 0 (meaning if it is null), then show 0, otherwise show 1.

What is the issue you are running into?

[#8]

this doesnt work,can u plz suggest something else.

actually in a qvd ,i have written match(fieldname,'y','n')

and in a qvw written as :

if(fieldname='','0','1')

so my requirement is where there is null values it shud polulate 0

and for yes/no it shud polulate as 1

[sunny_talwar]

Would you be able to share a sample where it isn't working? Cause I don't see a reason why it won't work....

[#10]

not giving any output