Future department with date range

[#1]

Hi.

I have a problem with HR file and count of people in different departments depending on the future date.

Example file is this:

name     start date     future-date     department     future-department

Smith     20140101     20140101     AA                 AA

Ballow     20140101     20140901    AA                 BB

How could I create a Qlikview filter to show the future-deparment for Ballow if I select a range from 20140101 to 20140901

and then show the deparment if I just select 20140101 to 20140601.

Regards mikael

[hic]

You should read about slowly changing dimensions...

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions

and

IntervalMatch and Slowly Changing Dimensions

HIC