topic Re: HR Dashboard Question. in QlikView

HR Dashboard Question.

MuraliPrasath — Tue, 27 May 2014 04:39:23 GMT

Hi,

I'm in the middle of HR Dashboard Project. Need help !! of "Age Distribution chart".

I've Emp ID, Name, Department, BirthDate, HireDate and so on.

How to write a expression to make out these.

tresB — Tue, 27 May 2014 04:49:02 GMT

Use class().

MuraliPrasath — Tue, 27 May 2014 04:59:07 GMT

Could you help me out? How to use class?

tresB — Tue, 27 May 2014 05:05:09 GMT

Theoritical you can learn from help or reference manual. For this scenario/practical - attach your sample qvw.

robert_mika — Tue, 27 May 2014 05:05:24 GMT

look at this example

Anonymous — Tue, 27 May 2014 05:17:25 GMT

First of all calculate Age for all employees via age function in script only.

example

age(today(),BirthDate) as EMP_AGE

where BirthDateshould be in date format.

Now Create a calculated dimension as

Class(EMP_AGE,5,'x')

Now whatever expression you have , you can provide and check your chart.

Anonymous — Tue, 27 May 2014 05:31:03 GMT

Always try to close the thread by providing Correct or Helpful answer tag to the replies....

It helps others to understand the solution....

MuraliPrasath — Tue, 27 May 2014 15:48:30 GMT

I figured it out !!

LOAD *,

if(ActiveHC.Age>=0 and ActiveHC.Age<=20,'0-20 Age',

if(ActiveHC.Age>=21 and ActiveHC.Age<=25,'21-25 Age',

if(ActiveHC.Age>=26 and ActiveHC.Age<=30,'26-30 Age',

if(ActiveHC.Age>=31 and ActiveHC.Age<=35,'31-35 Age',

if(ActiveHC.Age>=36 and ActiveHC.Age<=40,'36-40 Age',

if(ActiveHC.Age>=41 and ActiveHC.Age<=45,'41-45 Age',

if(ActiveHC.Age>=46 and ActiveHC.Age<=50,'46-50 Age',

if(ActiveHC.Age>=51 and ActiveHC.Age<=55,'51-55 Age',

if(ActiveHC.Age>=56 and ActiveHC.Age<=60,'56-60 Age',

if(ActiveHC.Age>=61 and ActiveHC.Age<=65,'61-65 Age','66 + Age')))))))))) as Age