Solved: Set Anlaysis - Qlik Community

Report Inappropriate Content · ‎2014-09-11

Hi Community,

I have employee Joining date field and current date(Period) field i want set analysis for number of total from employees joining date to current date(Period).

Thanks in advance.

MK_QSL · ‎2014-09-11

Try below expression ....

=Age(Today(),[Joining date]) &' Years '&(If(Day(Today()) >= Day([Joining date]), MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12),If(MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12) = 0, 11 , MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12)-1)) )&' Months '&(if(Day(Today()) >= Day([Joining date]), Day(Today())- Day([Joining date]), Today() - AddMonths([Joining date],12*AgeYears + If(MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12) = 0 , 11, MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12)-1))))&' Days'

View solution in original post

MK_QSL · ‎2014-09-11

Not Clear.. You want to find the total number of employees or total days employee joined?

senpradip007 · ‎2014-09-11

Can you explain bit more?

Report Inappropriate Content · ‎2014-09-11

Hi Manish,

i am giving example

suppose my employee joinning date is (16/12/2006) and my current date is my today date(11/09/2014) so i want total no of years and day expecated ans is(8) years.

so how i Count this?

PrashantSangle · ‎2014-09-11

Hi,

Try like

Count({calenderDateField={">=$(=date(max(EmployeeJoiningDate)))<=Date(Today())"}}Employee)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

PrashantSangle · ‎2014-09-11

Hi,

try with interval()

like

interval(today()-employeeJoiningDate,'D')

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ogster1974 · ‎2014-09-11

To find the number of employees that have joined from a particular date you could use.

count({<Joined Date>={<Your date>}>} Employee)

MK_QSL · ‎2014-09-11

Age(Today(),[Joining Date])

ajaykumar1 · ‎2014-09-11

Hi,

count({<Joined Date={"<=$(=max(period))"}>} Employee)

Regards,

Ajay

Report Inappropriate Content · ‎2014-09-11

hi every one,

Once again i repeat my qustion with example-:

I have one employee id=100 his joining date is (14/12/2006) and want set analysis how many years he working in organization? till today date(11/09/2014)

Set Anlaysis

Related Topics