Age Analysis

[#1]

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]

Could you share your data?

[mukesh24]

Hi,

Use Age() to calculate date difference

[manojkulkarni]

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

[amit_saini]

Hi,

Check links below:

http://community.qlik.com/message/493437#493437

http://community.qlik.com/message/683508#683508

Thanks,
AS

[#6]

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

[robert_mika]

I can not see those two fields in your data set

[#8]

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

[#9 · Accepted solution]

Hi,

May be this code will be useful.

[#10]

Thank you! This heps a lot