Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Future department with date range

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

1 Reply
hic
Former Employee
Former Employee