topic Re: Age Function in Qliksense in QlikView

Age Function in Qliksense

Anonymous — Thu, 08 Mar 2018 11:48:47 GMT

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 — Thu, 08 Mar 2018 11:51:49 GMT

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

Required answer for it.

Attachment.

shraddha_g — Thu, 08 Mar 2018 16:23:06 GMT

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

Use this flag in Expression

Anonymous — Thu, 08 Mar 2018 16:54:16 GMT

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 — Mon, 12 Mar 2018 22:28:38 GMT

Hi,

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

Regards