Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Load values in a column if not equal to

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")

1 Solution

Accepted Solutions
Not applicable

Re: Re: Load values in a column if not equal to

My code:

LOAD

organization_name

FROM

(ooxml, embedded labels)

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

7 Replies
Employee
Employee

Re: Load values in a column if not equal to

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');

8-12-2014 4-04-16 PM.png

Regards,
Mike Tarallo
Qlik
Not applicable

Re: Load values in a column if not equal to

How may I do the opposite?

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

Employee
Employee

Re: Load values in a column if not equal to

Hi

Match() = 0;

Not applicable

Re: Load values in a column if not equal to

Thank you!

Employee
Employee

Re: Re: Load values in a column if not equal to

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

Regards,
Mike Tarallo
Qlik
Not applicable

Re: Re: Load values in a column if not equal to

My code:

LOAD

organization_name

FROM

(ooxml, embedded labels)

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

Employee
Employee

Re: Load values in a column if not equal to

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

Regards,
Mike Tarallo
Qlik
Community Browser