Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

empty cell and null values

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 

1 Solution

Accepted Solutions
sunny_talwar

@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

View solution in original post

2 Replies
smilingjohn
Specialist
Specialist
Author

HI Expertise,

Any solution on my issue 

 

sunny_talwar

@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