Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatasreekanth2020

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

7 Replies
tresesco
MVP
MVP

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?

venkatasreekanth2020
Author

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
MVP
MVP

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?

venkatasreekanth2020
Author

Hi Tresesco,

Requesterdate is in between the Hiredate & Sep date

tresesco
MVP
MVP

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

venkatasreekanth2020
Author

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

venkatasreekanth2020
Author

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