topic Re: AGE ANALYSIS in QlikView

AGE ANALYSIS

renuka_sasikumar — Tue, 13 Jan 2015 08:44:25 GMT

Hi,

I have a DOB Field & a LinkCommonDate in which I want to show age analysis

Which means which are the (Count()Employee) employees following in the age buckets

AGE ANALYSIS		% \| VALUE

VERTICAL	18-25	26-35	36-45	46-55	56-60	> 60
X
Y
Z

All

Thanks & Regards,

Renuka S

Re: AGE ANALYSIS

alexandros17 — Tue, 13 Jan 2015 09:02:13 GMT

What is the problem?

Re: AGE ANALYSIS

Tue, 13 Jan 2015 09:08:06 GMT

Here we have to calculate the age of every employed with help of Current date - DOB and store in the other field.

Then we also i have make a Age_Bucket field which will have records

18-25

26-35

36-45

46-55

56-60

> 60

Then we can show age analysis in the pivot chart as you wish to do so.

Re: AGE ANALYSIS

mdmukramali — Tue, 13 Jan 2015 09:11:20 GMT

Dear Renuka,

Kindly find the attache sample file.

I hope it will full fill your requirement.

Replace(Class(Age(today(), DOB),10),'<= x <','-') as AgeRange;

//Dual('Age ('&Replace(Class(Age(today(), DOB),10),'<= x <','-')&')',Class(Age(today(), DOB),10)) as AgeRange;

Thanks,

Mukram

Re: AGE ANALYSIS

renuka_sasikumar — Tue, 13 Jan 2015 09:31:29 GMT

Hi,

There is no any sample file attached

Thanks & Regards,

Renuka S

Re: AGE ANALYSIS

renuka_sasikumar — Tue, 13 Jan 2015 09:34:56 GMT

Hi,

i have created the buckets in the front end. but it is not working without selection based.

Re: AGE ANALYSIS

mdmukramali — Tue, 13 Jan 2015 09:40:06 GMT

Dear,

Find the attached file.

Thanks

Mukram

Re: AGE ANALYSIS

Tue, 13 Jan 2015 09:47:44 GMT

Is this what you wanted in the results?

Re: AGE ANALYSIS

vikasmahajan — Wed, 14 Jan 2015 05:33:41 GMT

Hii

Renuka if you are using sql backend then create age buckets in script using following scripts

'Age_Bucket' =

CASE

WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 < 25 or DATEDIFF(day, d_date_of_birth, GETDATE())/365 IS NULL THEN '< 25 Yr'

WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=25 and DATEDIFF(day, d_date_of_birth, GETDATE())/365 <35 THEN '25-35 Yrs'

WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=35 and DATEDIFF(day, d_date_of_birth, GETDATE())/365 <45 THEN '35-40 Yrs'

WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=45 and DATEDIFF(day, d_date_of_birth, GETDATE())/365 <55 THEN '40-55 Yrs'

WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=55 THEN 'Above 55 Yrs+'

END

and then use this Age_Bucket Field in chart

I have implemented same logic . pfa sample chart image also.

Vikas