topic Re: Comparing DOB, resigning and total time assign in QlikView

Comparing DOB, resigning and total time assign

Thu, 15 Jan 2015 16:40:12 GMT

Hello,

I have Date of Birth of a group of persons also Employed date and for each of the persons can stay a maximum of 35 years if less than 60 years but resigns if equal to 60 years. Hope not confusing?

Note:

To be able to see all staffs that have resigned on a separate table or list box.
To be able to see number of Years/Month/Days a staff has worked so far in the company in the table
To be able to see number of Years/Month/Days remaining for a staff in the complany in the table

Re: Comparing DOB, resigning and total time assign

Thu, 15 Jan 2015 17:13:13 GMT

Hi Emma,

have a look the 'Age' function to help you with this. Can help you get the age in year of the employee and the time in years they have been employed for.

Age(today(), [DateofBirthField]) AS Employee age

Age(today(), [Employmentdatefield) AS YearInemployment

can then do comparisons on the different ages to demine if they are resigned or not

hope that helps

Joe

Re: Comparing DOB, resigning and total time assign

Fri, 16 Jan 2015 06:06:53 GMT

Joe,

I have done something similar.

Re: Comparing DOB, resigning and total time assign

Fri, 16 Jan 2015 09:28:28 GMT

that should help you then, if you are having a specific problem from there, you might want to post up an example app of the work you have done