topic Re: empty cell and null values in QlikView

empty cell and null values

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise ,

I have to bucket certain values of the field Environment which has the entry as 'null' and also there as some empty cells with no entries to which i have to include both 'null ' and blank entries into Unknown . to do so i am trying to use belwo script but this is not working . Can you pease help me on this ? but this below expression gives me reloading error like wrong expression

Script:

if(WildMatch(ENVIRONMENT,'Green','Green '),'Green',
if(WildMatch(ENVIRONMENT,'Check','Harvesting'),'UnderDev',
if(WildMatch(ENVIRONMENT,'Better'),'Better',
if(WildMatch(ENVIRONMENT,'null'or
IsNull(ENVIRONMENT),'UNKNOWN',
))))) as environment

Thanks in advance

Re: empty cell and null values

smilingjohn — Thu, 08 Oct 2020 11:24:54 GMT

HI Expertise,

Any solution on my issue

Re: empty cell and null values

sunny_talwar — Thu, 08 Oct 2020 12:00:39 GMT

@smilingjohn try this

If(WildMatch(ENVIRONMENT, 'Green*',), 'Green', If(WildMatch(ENVIRONMENT, 'Check', 'Harvesting'), 'UnderDev', If(WildMatch(ENVIRONMENT, 'Better'), 'Better', If(WildMatch(ENVIRONMENT,'null') or IsNull(ENVIRONMENT), 'UNKNOWN')))) as environment