Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
If(Len(Trim(x)) = 0, 0, 1) as Flag
so in the above how it will polulate 0 for null(-) values
so currently i have written as
if(x='','0','1')
Len(Trim()) will check for the Nulls
it will check fr null values,
but how it will polulate 0 in thse null values
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?
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
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....
not giving any output