topic Re: Age Analysis in QlikView

Age Analysis

Tue, 03 Mar 2015 06:09:00 GMT

Hi All

I have to fields namely "CustInvoice Year" and "Custpayment Year". The two fields contain years ie.2012,2011,2009...etc

I am required to calculate the basic customer aging using these two fields, how can I do this?

robert_mika — Tue, 03 Mar 2015 06:22:23 GMT

Could you share your data?

mukesh24 — Tue, 03 Mar 2015 06:22:37 GMT

Hi,

Use Age() to calculate date difference

manojkulkarni — Tue, 03 Mar 2015 06:24:15 GMT

If you could share some sample data, then it will be much easier to try

amit_saini — Tue, 03 Mar 2015 06:33:35 GMT

Hi,

Check links below:

Thanks,
AS

Tue, 03 Mar 2015 07:32:22 GMT

Here is t data. I must use these wo tables to calculate the age analysis.

robert_mika — Tue, 03 Mar 2015 10:38:16 GMT

I can not see those two fields in your data set

Tue, 03 Mar 2015 11:13:59 GMT

Hi,

You have concatenate both table but there is no common data on selection of TranYear or InvoiceYear.

Firstly concatenate both data with common key.

If you will select one invoice number then for that particular case both date should be available.

Regards

Vimlesh

Tue, 03 Mar 2015 11:24:28 GMT

Hi,

May be this code will be useful.

Tue, 03 Mar 2015 12:01:13 GMT

Thank you! This heps a lot