Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
nishaindia86
New Contributor

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
nishaindia86
New Contributor

Re: Age Function in Qliksense

Hi

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

Required answer for it.

Attachment.

Partner
Partner

Re: Age Function in Qliksense

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

Use this flag in Expression

nishaindia86
New Contributor

Re: Age Function in Qliksense

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

nishaindia86
New Contributor

Re: Age Function in Qliksense

Hi,

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

Regards