Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm having a problem with a new field created on the load editor with other fields.
I need to create an AgeRange, this is my code.
Leg:
LOAD "Age_em",
If(Age_em <=17, '<17 Years',
IF(Age_em >= 17 and Age < 25, '17 - 25',
IF(Age_em >= 25 and Age < 30, '25 - 30',
IF(Age_em >= 30 and Age < 40, '30 - 40',
IF(Age _em>= 40 and Age_em < 50, '40 - 50',
'50+'))))) as AgeRange;
When I load the data i dont have any error, but then the field does not appear when I want to use it on a Bar chart.
Thanks!!
Caro.
.