Discussion board where members can get started with QlikView.
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
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?
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:
my O/P like:
But the actual output has two EmpID, like:
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?
Requesterdate is in between the Hiredate & Sep date
that is holding true for both the cases. Isn't it?
please help me out of it......
form this The requsterdate is between the hiredate & Sepdate
Now there has to be a logicto decide that only EmpID -00025045 is considered out of them. The one with minimum hiredate