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: 
Anonymous
Not applicable

Age Function in Qliksense

Hi ,

I want that which customer is below the age of 16 year old.

In one of the table we have as column Birthdate.

Please find the attached example sheet of it.

Could you help me on this how we can achieve above requirement.

Is it that we need to create a flag at script level ?using age function?

Please suggest and send me the code for it if possible.

Regards

4 Replies
Anonymous
Not applicable
Author

Hi

Below question is not answered yet its by mistakley marked as answerd.

Required answer for it.

Attachment.

shraddha_g
Partner - Master III
Partner - Master III

if(Age(date(today()),date(BirthDate)) <16,1,0) as [<16 Flag]

Use this flag in Expression

Anonymous
Not applicable
Author

Hi Sharddha,

Thanks for quick response if I want to add count of unique Customer number in it.

How would be the expression then.

Regards

Anonymous
Not applicable
Author

Hi,

I haven't received any reply from sharddha could please meet my above requirement as well in the same code.

Regards