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

Hey can anyone help me tame this Horrifying Error Please,Would appreciate it.

Well the script is:

  ,Date([date_of_birth],'DD/MM/YYYY') AS date_of_birth

//    , Date(Date#([date_of_birth],'DD/MM/YYYY'),'DD/MM/YYYY') AS Date_Of_Birth

//    , age(today(),  Date([date_of_birth],'DD/MM/YYYY')) as Age,

//    if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) > 14, 'Under 14') As Age_Group,

//   

//     if(Age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 4 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 1, '1 - 4',  

//     if(Age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 9 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 5, '5 - 9',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 14 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 10, '10 - 14',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 19 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 15, '15 - 19',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 24 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 20, '20 - 24',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 29 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 25, '25 - 29',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 34 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 30, '30 - 34',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 39 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 35, '35 - 39',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 44 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 40, '40 - 44',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 49 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 45, '45 - 49',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 54 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 50, '50 - 54',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 59 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 55, '55 - 59',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 64 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 60, '60 - 64',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 69 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 65, '65 - 69',

//    // if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) > 85, 'Over 85',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 74 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 70, '70 - 74',

//     if(Age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 79 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 75, '75 - 79',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) <= 84 and age(today(),  Date([Date_Of_Birth],'DD/MM/YYYY')) >= 80, '80 - 84',

//     if(age(today(),  Date([date_of_birth],'DD/MM/YYYY')) > 84, 'Over 84',

//    //,Date([date_of_birth],'DD/MM/YYYY') AS date_of_birth

//

Iv commented everything out as iv tried many different methods,Closest iv gotten is john witherspoon's technique....

But it doesnt support my age ranges...Would love a response,AS IM GOING NUTS AT THIS VERY MOMENT.

Thanks CLOVER

1 Solution

Accepted Solutions
SunilChauhan
Champion
Champion

use can use

class(date(([Date_Of_Birth],'DD/MM/YYYY')),5)  to skip above code

hope this helps

Sunil Chauhan

View solution in original post

1 Reply
SunilChauhan
Champion
Champion

use can use

class(date(([Date_Of_Birth],'DD/MM/YYYY')),5)  to skip above code

hope this helps

Sunil Chauhan