Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
carotravaglini
Contributor II
Contributor II

Field created on load editor is not showing to use on charts

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. 

carotravaglini_0-1625082967515.png

 

Thanks!! 

Caro.

 

1 Reply
carotravaglini
Contributor II
Contributor II
Author

.