Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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