Intervalmatch problems

[#1]

Hi,

I am moving my load scripts from Qlikview to Qlik Sense and have encountered an error. Would someone be able to assist?

The section of load script is;

AgeGroups:
LOAD * INLINE [
    Bottom, Top, AgeGroup
0, 0.99, 0
1, 4.99, 1-4
5, 9.99, 5-9
10, 14.99, 10-14
15, 19.99, 15-19
20, 24.99, 20-24
25, 29.99, 25-29
30, 34.99, 30-34
35, 39.99, 35-39
40, 44.99, 40-44
45, 49.99, 45-49
50, 54.99, 50-54
55, 59.99, 55-59
60, 64.99, 60-64
65, 69.99, 65-69
70, 74.99, 70-74
75, 79.99, 75-79
80, 84.99, 80-84
85, 200, 85+
];

IntervalMatch(Patient_age)
left join(AgeGroups)

load Bottom, Top Resident AgeGroups;

drop fields Bottom, Top;

I am attempting to find an age group for each Patient_age. The Patient_age field is loaded prior to the execution of this script.

I get the following error;

Field not found: IntervalMatch(Patient_age) left join(AgeGroups) load Bottom, Top Resident AgeGroups

The script worked fine in Qlikview.

Any help would be much appreciated.

Cheers

Ian

[oknotsen]

Are you maybe using a QUALIFY statement earlier in your script, before you load Patient_age, that you forgot to close with an UNQUALIFY *; ? During training I often notice participants forgetting the star.

If that is not the case, could you show us the line of script right before you load that AgeGroups Inline table and the part in which you load Patient_age? Maybe it is just a silly typo or a missing ;

[#3]

Hi Onno,

Thanks for your reply. I have sorted out the problem by recopying my load script. Not sure what happened but it appeared that the field Patient_age was not loading properly.

Regards

Ian