Load values in a column if not equal to

[#1]

I have some values(lets say red, blue, green, orange, black, yellow, (blank) ) in column A.

How can I load column A with only red, blue, and yellow?

I am able to do

Load

if(A<> red, A)

How can I add multiple values and add the blank as well?

Thank you in advance

(Don't have access to "Discussion Forums")

[Michael_Tarallo]

Hello Cedric - as in: ?

LOAD

    Country,
    CountryISOCode,
    Customer,
    CustomerID,
       "Year",
    YearMonth
FROM 'c:\qliksense\data\gettingstarteddata.xls'
(biff, embedded labels, table is SalesData$)

Where Match(Country,'Brazil','Canada','Denmark');

[#3]

How may I do the opposite?

Where Not match (Country, 'Brazil', 'Canada', (and a blank value from excel)

[GabrielAraya]

Hi

Match() = 0;

[#5]

Thank you!

[Michael_Tarallo]

Cedric / Gabriel - did you get Match() =0; to work? - If so in what context?

Simply using match() = 0; does not work for me.

I got this to work for the opposite values, and my blank data seems to be excluded by default.

Where 1-Sign(Match(Country,'Brazil','Denmark','Canada','Argentina'))

Thanks - just curious.

Mike

[#7 · Accepted solution]

My code:

LOAD

organization_name

FROM

(ooxml, embedded labels)

WHERE Match(organization_name,' ','New York')=0;

[Michael_Tarallo]

Hi Cedric - BTW one note - please take a look at this post to see how QlikView / Qlik Sense handles NULLS, <blank>, NOTHING - because they are not always created equally. I want to make sure your test case is accurate.

NULL handling in QlikView

Regards,

Mike