topic Re: Need Help?? in QlikView

Need Help??

Nagaraju_KCS — Wed, 18 Mar 2015 06:01:27 GMT

Hi All,

I have to calculate how many years working, i am using AGE function.

like Age(DOJ, Resignation_Date)

Sample Example..

this is my table i want to exclude 0-3 months Experience.. persons

i want to calculate only 4 moths to upper experence....

EmpName DOJ Resignation Date

Raju	16/10/2013	10/02/2014
sunil	06/02/2012	07/03/2012
sampath	17/11/2014	17/11/2014
reddy	14/09/2009	18/10/2012
amith	12/03/2014	01/08/2014
sandya	19/04/2010	27/11/2012
Apporv	25/08/2014	29/08/2014
Sameer	03/10/2011	26/04/2013
Akil	12/01/2009	26/07/2012
Nitya	13/12/2010	27/05/2013
Satya	03/08/2009	15/05/2013
Viktanth	07/07/2011	22/10/2013
santu	20/01/2014	03/11/2014
banti	23/04/2009	23/04/2012

Hope you Undersatand .......!!!!

Thanks in Advance......

Re: Need Help??

Ralf-Narfeldt — Wed, 18 Mar 2015 06:14:01 GMT

The most simple thing would be if you used 90 days instead of 3 months as the condition. Then it's a really simple Where clause to add at the end of the Load statement:

WHERE ResignationDate - DOJ > 90

Re: Need Help??

Wed, 18 Mar 2015 06:15:45 GMT

Hi,

use Interval([Resignation Date]-[DOJ ]) as Days

if you want more than 3 months of employee then use this code

if(Days/30<=3,'0',1) as flag

0 is less than or equal to 3 months experience and 1 is more than than 3 months experience.

Regards

Vimlesh

Re: Need Help??

sagarkharpude — Wed, 18 Mar 2015 06:23:49 GMT

Try this

if(NetWorkDays(DOJ,Resignation_Date)>90,1,0) as flag

And use flag=1 in your chart

Re: Need Help??

MK_QSL — Wed, 18 Mar 2015 07:33:34 GMT

Table:

Load

Where Days > 30;

Load

EmpName,

Date(DOJ) as DOJ,

Date([Resignation Date]) as [Resignation Date],

Interval([Resignation Date] - DOJ,'DD') as Days

Inline

[

EmpName, DOJ, Resignation Date

Raju, 16/10/2013, 10/02/2014

sunil, 06/02/2012, 07/03/2012

sampath, 17/11/2014, 17/11/2014

reddy, 14/09/2009, 18/10/2012

amith, 12/03/2014, 01/08/2014

sandya, 19/04/2010, 27/11/2012

Apporv, 25/08/2014, 29/08/2014

Sameer, 03/10/2011, 26/04/2013

Akil, 12/01/2009, 26/07/2012

Nitya, 13/12/2010, 27/05/2013

Satya, 03/08/2009, 15/05/2013

Viktanth, 07/07/2011, 22/10/2013

santu, 20/01/2014, 03/11/2014

banti, 23/04/2009, 23/04/2012

];

Re: Need Help??

MK_QSL — Wed, 18 Mar 2015 07:37:48 GMT

If you want to use 3 Months instead of 90 days, use as below

Table:

Load

Where Months > 3;

Load

EmpName,

Date(DOJ) as DOJ,

Date([Resignation Date]) as [Resignation Date],

(Year([Resignation Date]) * 12 + Month([Resignation Date])) - (Year(DOJ) * 12 + Month(DOJ)) as Months

Inline

[

YourData

];

Re: Need Help??

hariprasadqv — Wed, 18 Mar 2015 07:44:35 GMT

Hi, manish solution is awsome as per my view.

Re: Need Help??

jagan — Wed, 18 Mar 2015 08:04:59 GMT

Hi,

Check this link for getting months difference

Calculating Months difference between two dates

Follow the above above post and use below script

Data:

LOAD

WHERE MonthsDifference > 3;

LOAD

EmpName,

DOJ,

ResignationDate,

($(MonthDiff(DOJ, ResignationDate)) AS MonthsDifference

FROM DataSource;

Hope it helps you.

Regards,

Jagan.