topic Re: To find age between two dates in QlikView

To find age between two dates

Thu, 15 Oct 2015 10:52:54 GMT

Hello,

my question is for given attachment. I've two tables Opportunity and lead. In opportunity there is Closedate and CreatedDate in Lead table. I want Opportunity Close Date – Lead Creation Date to compute Age. Can I get solution?

Re: To find age between two dates

Gysbert_Wassenaar — Thu, 15 Oct 2015 11:59:37 GMT

How are the records in the Lead table related to those in the Opportunities table? What's the key to link the tables?

Re: To find age between two dates

Thu, 15 Oct 2015 12:10:30 GMT

That's the main problem which I'm facing to link those tables and get age output. but I saw something link between ConvertedOpportunityId in lead table and Id in Opportunity table.

please get the solution for this Problem.

Thanks for Reply.

Re: To find age between two dates

rohit214 — Thu, 15 Oct 2015 12:45:04 GMT

you can use AGE function check it on help

or you can create bucket if(Num(Opportunity Close Date) - Num(Lead Creation Date)<=90, '3months',

If(Num(Opportunity Close Date) - Num(Lead Creation Date)>90<=180,'6 Months',

If(Num(Opportunity Close Date) - Num(Lead Creation Date)>180<=365,'1 year'))) and so on you can create the bucket.

Hope it helps you.

Regards,

Rohit

Re: To find age between two dates

Thu, 15 Oct 2015 13:59:51 GMT

That's the main problem which I'm facing to link those tables and get age output. but I saw something link between ConvertedOpportunityId in lead table and Id in Opportunity table.

please get the solution for this Problem.

Re: To find age between two dates

Qrishna — Thu, 15 Oct 2015 14:10:35 GMT

As Gysbert Asked earlier, I too have the same question before we can make any attempts to help you out/.

Whats the Key field which links both the tables?.

Re: To find age between two dates

Thu, 15 Oct 2015 14:18:45 GMT

That's the main problem which I'm facing to link those tables and get age output. but I saw something link between ConvertedOpportunityId in lead table and Id in Opportunity table.

please get the solution for this Problem.