Re: Help related to Interval match - Qlik Community

Anonymous · ‎2014-08-25

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

tresesco · ‎2014-08-25

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?

Anonymous · ‎2014-08-25

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

tresesco · ‎2014-08-25

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?

Anonymous · ‎2014-08-25

Hi Tresesco,

Requesterdate is in between the Hiredate & Sep date

tresesco · ‎2014-08-25

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

Anonymous · ‎2014-08-25

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

Anonymous · ‎2014-08-25

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