Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

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

marianagronroos
New Contributor II

Re: Flag both null and certain values

Thank you for your help!