topic Re: Age Bucket in QlikView

Age Bucket

rahulsingh12 — Wed, 30 Aug 2017 16:51:00 GMT

Hi,

I have created a link table using two table A and B.

Both the tables have a date field in them.

I want to create age bucket using that link table such that when ever any value of the common date from link table is selected it should calculate the age for that date from table A and B till the common date from Link Table.

A----->Link Table<-----B

Regards,

Re: Age Bucket

el_aprendiz111 — Wed, 30 Aug 2017 17:20:23 GMT

function Interval(Date1,Date2,'d')

Would you be able to share a sample with the expected output?

Re: Age Bucket

rahulsingh12 — Wed, 30 Aug 2017 18:14:23 GMT

Hi i have attached a file.

From the link table date field and the date field from any of the table A and B I want to create a age bucket.

Link Table

29/04/2015

24/05/2017

Age_Bucket

<30 days

This bucket will change when the selection of common date changes.

Regards