topic Re: flag identifiers in QlikView

flag identifiers

Wed, 22 Mar 2017 14:26:22 GMT

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

Re: flag identifiers

sunny_talwar — Wed, 22 Mar 2017 14:28:35 GMT

May be like this

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

Re: flag identifiers

Wed, 22 Mar 2017 14:31:37 GMT

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

Re: flag identifiers

Wed, 22 Mar 2017 14:39:47 GMT

so currently i have written as

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

Re: flag identifiers

sunny_talwar — Wed, 22 Mar 2017 14:41:27 GMT

Len(Trim()) will check for the Nulls

Re: flag identifiers

Wed, 22 Mar 2017 15:05:54 GMT

it will check fr null values,

but how it will polulate 0 in thse null values

Re: flag identifiers

sunny_talwar — Wed, 22 Mar 2017 15:08:21 GMT

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?

Re: flag identifiers

Thu, 23 Mar 2017 08:54:10 GMT

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

Re: flag identifiers

sunny_talwar — Thu, 23 Mar 2017 08:56:46 GMT

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....

Re: flag identifiers

Thu, 23 Mar 2017 09:04:51 GMT

not giving any output

Re: flag identifiers

sunny_talwar — Thu, 23 Mar 2017 09:06:42 GMT

Great.... I am sure someone else might be able to help..

All the best

Re: flag identifiers

Anonymous — Thu, 23 Mar 2017 09:36:42 GMT

Keep the qvd with the same logic you mentioned...match(fieldname,'y','n')

When loading the qvd into your qvw sunny is correct that this should work

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