Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
marianagronroos
New Contributor II

Flag both null and certain values

Hi,

I have customers with addresses: some of them have a countrycode, while some of them have "null" countrycode. I want to find, (with an  action-button, Select in Field) the customers, that have vaules 6 or 7 or null. Should I flag them in the script? How can I flag both null-values and certain values?

1 Solution

Accepted Solutions
MVP
MVP

Re: Flag both null and certain values

A flag in the script could look like

CountryTable:

LOAD

     Country,

     CountryCode,

     If(len(trim(CountryCode))=0 or match(CountryCode ,6,7),1,0) as CountryCodeFlag,

     ...

FROM ...;

View solution in original post

2 Replies
MVP
MVP

Re: Flag both null and certain values

A flag in the script could look like

CountryTable:

LOAD

     Country,

     CountryCode,

     If(len(trim(CountryCode))=0 or match(CountryCode ,6,7),1,0) as CountryCodeFlag,

     ...

FROM ...;

View solution in original post

marianagronroos
New Contributor II

Re: Flag both null and certain values

Thank you for your help!