topic Re: Error when creating age group in QlikView

Error when creating age group

Anonymous — Wed, 01 Jun 2011 16:52:31 GMT

mem_age_tmp:

LOAD

MEM#,

if(Age >= 18, '>=18',

if(Age <= 17 and Age >= 0, '0-17')) as Age_Group

Resident mem;

I tried to create a couple of Age_Group using the above code but I am getting an error when I run it.

What is wrong with the above code? Any help would be greatly appreciated.

Thanks.

Error when creating age group

Wed, 01 Jun 2011 17:02:35 GMT

Hi, could you be more specific about the error thrown by QlikView, because your syntaxis looks alright to me. Also, when I create age groups, I always use the intervalmatch function within the script, or a calculated dimension using the class function within the GUI, I suggest to use one of those, depending on your requirement, since they are much easier to handle and mantain.

Regards

Re: Error when creating age group

Anonymous — Wed, 01 Jun 2011 17:06:16 GMT

Hi.

I think you don't have the second "if" statement complete.

Qlikiview if is a ternary expression, and the third parameter is mandatory.

I believe this will load:

LOAD

MEM#,

if(Age >= 18, '>=18',

if(Age <= 17 and Age >= 0, '0-17','Other?')) as Age_Group

Resident mem;

Even if the "else" does not exist.

Hope it helps,

Miguel Catalão

Re: Error when creating age group

Wed, 01 Jun 2011 17:13:01 GMT

Hi, actually the third parameter is not mandatory, QV will evaluate to a null value in the case that a value does not meet the condition and the else parameter was not provided, but it will never be the source of a script error.

Regards

Re: Error when creating age group

Anonymous — Wed, 01 Jun 2011 17:16:17 GMT

Oh, you are right, just tested it.

I also tested the full load expression with the chained "if"'s and it seems ok.

Can you debug the code and see where it stops?

Re: Error when creating age group

Wed, 01 Jun 2011 17:45:35 GMT

Hi again, is QV returning a general script error??, because sometimes I happen to write my code ok, and QV seems to find a unexistent error, what I do to solve is close QV completely and open it again.

Hope tis helps.

Regards

Error when creating age group

Anonymous — Wed, 01 Jun 2011 18:01:16 GMT

Hi Ivan,

The error message is

Error in expression:l')' expected

mem_age_tmp:

LOAD

MEM#,

if(Age >=18,'>=18',

if(Age <= 17 and Age=>0,'0-17')) as Age_Group

Resident mem

As an FYI, Age is calculated in a load that ran previous to this. The table is calls mem. I listed the code below:

mem:

LOAD

MEM#,

//MEM#,

//MEM# as Pharm_MEM#,

//MEM# as Med_MEM#,

NAME,

DOB,

Age('12/31/2011',DOB) as Age,

[MED MONTHS],

[PHAR MONTHS],

[RAW ACG],

[PRE COST],

[PROB INP],

AGGREGATE,

ADDRESS,

CITY,

STATE,

[ZIP CODE]

FROM

Data\Dimensions\mem.qvd

(qvd);

Error when creating age group

Wed, 01 Jun 2011 19:12:42 GMT

Hi, I see the error now, it seem obvious but is hard to see, the last greater or equal symbol is written as "=>" when the correct notation should be ">=".

Regards

Error when creating age group

Anonymous — Wed, 01 Jun 2011 20:58:15 GMT

Hi Ivan,

That was the problem. Thank you!