Age Function in Qliksense - Qlik Community

Anonymous · ‎2018-03-08

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

Anonymous · ‎2018-03-08

Hi

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

Required answer for it.

Attachment.

shraddha_g · ‎2018-03-08

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

Use this flag in Expression

Anonymous · ‎2018-03-08

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 · ‎2018-03-12

Hi,

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

Regards