topic Set Anlaysis in QlikView

Set Anlaysis

Thu, 11 Sep 2014 11:06:03 GMT

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.

Re: Set Anlaysis

MK_QSL — Thu, 11 Sep 2014 11:07:49 GMT

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

Re: Set Anlaysis

senpradip007 — Thu, 11 Sep 2014 11:09:58 GMT

Can you explain bit more?

Re: Set Anlaysis

Thu, 11 Sep 2014 11:16:35 GMT

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?

Re: Set Anlaysis

PrashantSangle — Thu, 11 Sep 2014 11:17:05 GMT

Hi,

Try like

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

Regards,

Re: Set Anlaysis

PrashantSangle — Thu, 11 Sep 2014 11:18:35 GMT

Hi,

try with interval()

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

Regards,

Re: Set Anlaysis

ogster1974 — Thu, 11 Sep 2014 11:19:06 GMT

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

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

Re: Set Anlaysis

MK_QSL — Thu, 11 Sep 2014 11:24:24 GMT

Age(Today(),[Joining Date])

Re: Set Anlaysis

ajaykumar1 — Thu, 11 Sep 2014 11:31:17 GMT

Hi,

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

Regards,

Ajay

Re: Set Anlaysis

Thu, 11 Sep 2014 12:09:14 GMT

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)

Re: Re: Set Anlaysis

ajaykumar1 — Thu, 11 Sep 2014 12:14:13 GMT

Hi,

year(today())-year(joining date)

Re: Set Anlaysis

PrashantSangle — Thu, 11 Sep 2014 12:16:39 GMT

Hi,

as Manish suggested Age() gives you desired result.

then write

Year(Today())-Year(Date(Date#(JoiningDate),'DD/MM/YYYY'),'DD/MM/YYYY')

Regards

Re: Set Anlaysis

Thu, 11 Sep 2014 12:36:45 GMT

Hi Max i used this expression but it not working any other solution.

Re: Set Anlaysis

anbu1984 — Thu, 11 Sep 2014 12:46:55 GMT

Can you post app which you tried

Re: Set Anlaysis

Thu, 11 Sep 2014 12:47:10 GMT

Ajay has given the correct solution.

year(today())-year(joining date)

Please find attachment.

Re: Re: Set Anlaysis

Thu, 11 Sep 2014 12:59:55 GMT

Hi Ajay,

I got yearwise count ok,but i also want month,day wise calculation.

that means how many years,months and days?

Re: Set Anlaysis

MK_QSL — Thu, 11 Sep 2014 13:06:05 GMT

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'

Re: Set Anlaysis

ajaykumar1 — Fri, 12 Sep 2014 04:11:53 GMT

Hi,

Manish expression working properly and i tested its working.

Thanks Manish its very helpfull to me also.

Re: Re: Set Anlaysis

Fri, 12 Sep 2014 04:13:22 GMT

Please find attachment.