Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
venkatasreekant
Valued Contributor

Help related to Interval match

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

Tags (1)
7 Replies
MVP
MVP

Re: Help related to Interval match

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?

venkatasreekant
Valued Contributor

Re: Help related to Interval match

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


MVP
MVP

Re: Help related to Interval match

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?

venkatasreekant
Valued Contributor

Re: Help related to Interval match

Hi Tresesco,

Requesterdate is in between the Hiredate & Sep date

MVP
MVP

Re: Help related to Interval match

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

venkatasreekant
Valued Contributor

Re: Help related to Interval match

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

venkatasreekant
Valued Contributor

Re: Help related to Interval match

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