Discussion board where members can get started with QlikView.
I am new to qlikview and have a requirement to create a chart that would display the no. of employees/dept left in a period of time.
in a period of 0-2 yrs employees left from dept suppose 'X' is 10.
similarly, in 2-4 yrs employees left from dept 'X' is 20 etc....
I am having the following fields:
Can anyone help me solving this.
May be this solve your requirement...
age(date(`Termination date`,'DD\MM\YYYY'),date(`Hire date`,'DD\MM\YYYY')) as INTERVAL
FrontEnd Dimensin: =class(INTERVAL,2,'Year')where 2 is interval like 0-2,2-4 etc
Good morning. Welcome to QV world.
Yes, this is possible. Please you load the sample data with your QV document? I can demostrate an example of your requirement.
Cheers - DV