Future department with date range

Mon, 19 May 2014 20:12:36 GMT

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

Re: Future department with date range

hic — Mon, 19 May 2014 20:27:24 GMT

You should read about slowly changing dimensions...

and

HIC