topic Re: urgnt issue in QlikView

urgnt issue

Anonymous — Tue, 22 Aug 2017 12:54:28 GMT

if(len(fieldx)='0',fieldy='N',

if(len(fieldx)>'0',fieldy='Y','unk')) as flag

its not gving desired output

Anil_Babu_Samineni — Tue, 22 Aug 2017 12:57:29 GMT

Just remove fieldy on your statement

if(len(fieldx)=0,'N', if(len(fieldx)>0,'Y','unk')) as flag

if(len(fieldx)=0 and fieldy='N', if(len(fieldx)>0 and fieldy='Y','unk')) as flag // May be use OR operator if needed

sunny_talwar — Tue, 22 Aug 2017 12:57:53 GMT

What is the desired output and what is the above giving? Can you share a sample?

marcus_malinow — Tue, 22 Aug 2017 13:14:21 GMT

this makes no sense!

once you have checked that fieldx has a length of zero, there's no need for your next if condition, as fieldx must have a length of more than zero.

antoniotiman — Tue, 22 Aug 2017 13:16:57 GMT

Maybe

if(len(fieldx)='0','N', if(len(fieldx)>'0','Y','unk')) as fieldy

Anonymous — Tue, 22 Aug 2017 13:35:28 GMT

output is ,it shud field y shud have n when there are null values in fieldx and

fieldy shud have y when the re are non null values in fieldx

antoniotiman — Tue, 22 Aug 2017 13:40:54 GMT

if(len(fieldx)='0','N', 'Y') as fieldy

Anonymous — Tue, 22 Aug 2017 13:41:18 GMT

try this,

anyway you should not get negative values so check for not nulls and assign the values.

if(len(fieldx)!=0,'Y', 'N')

marcus_malinow — Tue, 22 Aug 2017 13:45:01 GMT

if(IsNull(fieldx),'N','Y') as fieldy

bearing in mind that an empty string '' is not the same as a null