Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intervalmatch problems

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

2 Replies
oknotsen
Master III
Master III

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 ;

May you live in interesting times!
Not applicable
Author

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