Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Esteemed Contributor

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

use can use

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

hope this helps

1 Reply
SunilChauhan
Esteemed Contributor

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

use can use

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

hope this helps