topic Re: Using "if statement" in load statement in QlikView

Using "if statement" in load statement

jleefjcapital — Fri, 19 Jun 2015 21:55:16 GMT

I am using a panel dataset which contain two separate categories. I would like to separate out by one of the categories. For instance, I have one category which is region, and the other as employment type. I would like to write an if statement to only load the regions for a single employment type. I tried using the following, but it keeps causing an error- "Field not found" I think this statement implies that "management_occupations" is a field, but it's a value. How should I change this so that it only pulls the regions where OCC_TITLE = "Management_Occupations"?

Thank you.

LOAD

AREA_NAME as MSA,

"LOC QUOTIENT" as LQ_MSA,

H_MEDIAN,

If("OCC_TITLE" = [Management Occupations], "OCC_TITLE", NULL) as Management_Occupation

FROM [lib://Employment/MSA_M2014_dl.xlsx]

(ooxml, embedded labels, table is MSA_dl);

Re: Using "if statement" in load statement

ecolomer — Fri, 19 Jun 2015 22:01:27 GMT

Try writting Null() in your expresion.

Re: Using "if statement" in load statement

swuehl — Fri, 19 Jun 2015 22:06:54 GMT

Try

LOAD

AREA_NAME as MSA,

"LOC QUOTIENT" as LQ_MSA,

H_MEDIAN,

If("OCC_TITLE" = 'Management Occupations', "OCC_TITLE", NULL() ) as "Management_Occupation"

FROM [lib://Employment/MSA_M2014_dl.xlsx]

(ooxml, embedded labels, table is MSA_dl);

Re: Using "if statement" in load statement

ecolomer — Fri, 19 Jun 2015 22:08:21 GMT

This is the same I said

Re: Using "if statement" in load statement

swuehl — Fri, 19 Jun 2015 22:17:38 GMT

I added also single quotes around the literal 'Management Occupations'

Re: Using "if statement" in load statement

ecolomer — Fri, 19 Jun 2015 22:18:37 GMT

Ok, I'm sorry

Re: Using "if statement" in load statement

MarcoWedel — Sat, 20 Jun 2015 00:14:00 GMT

If(OCC_TITLE = 'Management Occupations', OCC_TITLE) as Management_Occupation

should also work.

regards

Marco

Re: Using "if statement" in load statement

jleefjcapital — Mon, 22 Jun 2015 15:27:58 GMT

Thank you!

Re: Using "if statement" in load statement

jleefjcapital — Mon, 22 Jun 2015 15:29:48 GMT

Thank you!

Re: Using "if statement" in load statement

jleefjcapital — Mon, 22 Jun 2015 15:30:03 GMT

Thank you!

Re: Using "if statement" in load statement

MarcoWedel — Tue, 23 Jun 2015 06:14:09 GMT

you're welcome

regards

Marco