I'm new to Qlikview, and doing my best trying to learn everything while at the same time trying to be productive. But I'm stuck at this point. 🙂
I have a table with start and end dates connected to employees, which are their employment periods. Now I need to filter out their new employments, ie the start date per employee, where there is not prior employment OR at least two years has passed since. If that makes sense.
Eg,
Empl Start End
1 2005-01-01 2005-07-01
1 2004-01-01 2004-07-01
...should filter out 2004-01-01, but...
Empl Start End
1 2008-01-01 2008-07-01
1 2004-01-01 2004-07-01
...should leave me with both 2004-01-01 and 2008-01-01.
Is this possible?
Thanksful for any help,
Stefan Haglund
