please help

[manisha_uit]

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

[#2]

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

[IAMDV]

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