Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
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.
Like,
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:
Hire date
Termination date
EMployeess
dept
Can anyone help me solving this.
Thanks
Manisha
May be this solve your requirement...
BackendScript:
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
Cheers
Deepak
Hi Manisha,
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