Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
manisha_uit
Contributor

please help

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 Replies
Not applicable

Re: please help

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

Luminary
Luminary

Re: please help

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

Community Browser