topic Bithday alert or reminder in QlikView

Bithday alert or reminder

Sun, 13 Apr 2014 15:24:29 GMT

Hello Experts,

I have requirement where i hava a database where various person name and its date of birth details available.

Data has in two fields PersonName and DOB

PersonName,DOB

P1,01/01/1982

P2,04/11/1965

P3,02/03/1985

P4,06/07/2001

P5,08/04/1972

1. By person its current age on current date by how many years, months, day.

2. If any person has birthday in the current month shows alert message or by promting any indication in dashboard.

3. Higest age and minimum age.

Until this requrement if more i added on the thread

Thanks

MK_QSL — Sun, 13 Apr 2014 16:38:51 GMT

Please find enclosed file...

Mon, 14 Apr 2014 08:20:50 GMT

Hi,

Thanks manish can you explain the load script i am newbie and cant understand proeprly.

Thanks

MK_QSL — Mon, 14 Apr 2014 08:36:57 GMT

It is just a mathematical calculation but difficult to explain.

You can do one thing...

Age(Today(),DOB) as AgeYears,

Try to find out how age function is working in QlikView Reference Manual

To understand the script, you need to understand below function... rest are just maths formulas.

Mode, Today(), AddMonths, Age..

Kindly mark correct/helpful answer if your requirement fulfilled.

Tue, 15 Apr 2014 10:20:34 GMT

Hi,

Is there another way of doing same..

Thanks

MK_QSL — Tue, 15 Apr 2014 10:27:40 GMT

Does my reply not fulfilled your requirements?