topic Re: please help in QlikView

please help

manisha_uit — Thu, 30 Jun 2011 07:15:14 GMT

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

Thu, 30 Jun 2011 08:02:44 GMT

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 — Fri, 01 Jul 2011 09:48:55 GMT

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