topic Re: Age in QlikView

Age

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I need to build one logic on Age buckets.But i m not able to do it.

Can any one hep me out in this.

I have Date fieldd Join Date and END date in my app.i m filtering Joining date .For Example i want to count Id's Passing Joining date <=31-07-2016 and I m getting ID of it. and Also i have DOB of ID.So for Every ID i have DOB , on this i want to create Age as On My Input DAte.

Exam One of My ID has 01-01-1960 To this ID I need to Create Age.

Re: Age

ankali1990 — Tue, 30 Aug 2016 16:45:40 GMT

Hello,

I read your post couple of times. You want to create second input box with DOB or the first one is not working?

Regards.

Re: Age

subbareddykm — Tue, 30 Aug 2016 16:56:36 GMT

i m not able to create age against every ID wise.

I want to create Age Bucket?

Did u see one calculated list box there ?

Its not working.

Re: Age

subbareddykm — Tue, 30 Aug 2016 16:59:46 GMT

I want out put like this :

ID	0-25	26-35	36-50	50&Above

and I want see ID belongs to which age group

Re: Age

agomes1971 — Tue, 30 Aug 2016 17:20:11 GMT

Hi,

please see attached.

Regards

André Gomes

Re: Age

subbareddykm — Tue, 30 Aug 2016 17:26:50 GMT

I dont want on Today(), user wants to consider his input date.

if i consider Today, age mismatch is coming.

Based on his input date ,we need to caluculate Age like that

Re: Age

svinnakota — Tue, 30 Aug 2016 19:28:45 GMT

Hi, I guess the input date which you are referring is VDate variable containing '31-07-2016'.

Adding to agomes1971‌ point. If you replace the Dimension Value Today() with $(VDate) i guess you can get the required output. If not please mention clearly what is the input date/column which you are referring to..

Let me know your comments..

Re: Age

MarcoWedel — Tue, 30 Aug 2016 23:47:33 GMT

Hi,

one solution might be:

hope this helps

regards

Marco