topic Re: Help related to Interval match in QlikView

Help related to Interval match

Anonymous — Mon, 25 Aug 2014 06:22:36 GMT

Hi Qlickers,

I need u r help in Interval Match,

please find the sample QVW file in the attachments,

In that for 1 requester position it will display 2 dates,

please tell me how to get a singledate between hire date & sep date

thanks in advance

Gysbert Wassenaar,Jagan Mohan,Miguel Angel Baeyens,tresesco

Re: Help related to Interval match

tresB — Mon, 25 Aug 2014 06:47:58 GMT

In your case Employees are different for different intervals, which seems okay to me. Do you still want the intervals to be generalized for them?

Re: Help related to Interval match

Anonymous — Mon, 25 Aug 2014 06:57:59 GMT

Hi Tresesco,

Please take a simple case

I selected a single case based on Requesterposition

Requester position 01000678 I get the result as 2 hiredates & 2 sep date but in requester date listbox it will display a single date i.e, 21/01/2013

based on the requester date I want to show only one hiredate,sepdate,EmpId

my O/P like:

RequsterPosion, hiredate,sepdate,EmpId

01000678 ,02/07/2012,11/10/2013,00025045

Re: Help related to Interval match

tresB — Mon, 25 Aug 2014 07:16:53 GMT

my O/P like:

RequsterPosion, hiredate,sepdate,EmpId

01000678 ,02/07/2012,11/10/2013,00025045

But the actual output has two EmpID, like:

RequsterPosion, hiredate,sepdate,EmpId

01000678 ,02/07/2012,11/10/2013,00025045

01000678 ,20/08/2012,30/12/9999,00025047

Now there has to be a logic how you decide that only EmpID -00025045 is considered out of them. The one with minimum hiredate? Or, what?

Am I missing something?

Re: Help related to Interval match

Anonymous — Mon, 25 Aug 2014 08:01:06 GMT

Hi Tresesco,

Requesterdate is in between the Hiredate & Sep date

Re: Help related to Interval match

tresB — Mon, 25 Aug 2014 08:04:40 GMT

that is holding true for both the cases. Isn't it?

Re: Help related to Interval match

Anonymous — Mon, 25 Aug 2014 08:10:23 GMT

Hi Tresesco,

please help me out of it......

my O/P like:

RequsterPosion, hiredate,sepdate,EmpId

01000678 ,02/07/2012,11/10/2013,00025045

Requesterdate:21/01/2013,

form this The requsterdate is between the hiredate & Sepdate

Re: Help related to Interval match

Anonymous — Mon, 25 Aug 2014 09:13:17 GMT

Hi Tresesco,

But the actual output has two EmpID, like:

RequsterPosion, hiredate,sepdate,EmpId

01000678 ,02/07/2012,11/10/2013,00025045

01000678 ,20/08/2012,30/12/9999,00025047

Now there has to be a logicto decide that only EmpID -00025045 is considered out of them. The one with minimum hiredate