topic calculate the age of debt, fifo payment in QlikView https://community.qlik.com/t5/QlikView/calculate-the-age-of-debt-fifo-payment/m-p/671397#M243909 <HTML><HEAD></HEAD><BODY><P>Hello, could someone give me an advice, how to solve a problem of showikg companies debts in order to their age? </P><P>Client has a huge amount of partners,&nbsp; lots of transactions. He wants to see debts of partners, dew to their age: wich debts are less then month, which 1-3 months, which 3-6 months... (the best- to be able to choose the limits in the app by himself....) He want to see it in different lines or colours of bars..</P><P>the payment scheme is FIFO: the new transfer goes to repay the oldest debt... So there are ... emm......steps...=) </P><P>I've tried to make different loops, but didn't succeed...i guess it best to do the calculations in the script, because there are few thousands of partners..</P><P>Could you kindly look at the app an advice how to solve the problem?</P><P>how should the age be calculated:</P><P><IMG alt="Screenshot_3.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69386_Screenshot_3.png" style="width: 620px; height: 302px;" /></P></BODY></HTML> Tue, 21 Oct 2014 13:26:39 GMT 2014-10-21T13:26:39Z calculate the age of debt, fifo payment https://community.qlik.com/t5/QlikView/calculate-the-age-of-debt-fifo-payment/m-p/671397#M243909 <HTML><HEAD></HEAD><BODY><P>Hello, could someone give me an advice, how to solve a problem of showikg companies debts in order to their age? </P><P>Client has a huge amount of partners,&nbsp; lots of transactions. He wants to see debts of partners, dew to their age: wich debts are less then month, which 1-3 months, which 3-6 months... (the best- to be able to choose the limits in the app by himself....) He want to see it in different lines or colours of bars..</P><P>the payment scheme is FIFO: the new transfer goes to repay the oldest debt... So there are ... emm......steps...=) </P><P>I've tried to make different loops, but didn't succeed...i guess it best to do the calculations in the script, because there are few thousands of partners..</P><P>Could you kindly look at the app an advice how to solve the problem?</P><P>how should the age be calculated:</P><P><IMG alt="Screenshot_3.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69386_Screenshot_3.png" style="width: 620px; height: 302px;" /></P></BODY></HTML> Tue, 21 Oct 2014 13:26:39 GMT https://community.qlik.com/t5/QlikView/calculate-the-age-of-debt-fifo-payment/m-p/671397#M243909 2014-10-21T13:26:39Z Re: calculate the age of debt, fifo payment https://community.qlik.com/t5/QlikView/calculate-the-age-of-debt-fifo-payment/m-p/671398#M243910 <HTML><HEAD></HEAD><BODY><P>You can use the class() function in a calculated dimension and it will bucket the days into ranges (0-30 , 31-60 etc..) </P><P></P><P>I opened your QVW but couldn't figure out which is the calculation to determine days. </P></BODY></HTML> Tue, 21 Oct 2014 14:43:27 GMT https://community.qlik.com/t5/QlikView/calculate-the-age-of-debt-fifo-payment/m-p/671398#M243910 JonnyPoole 2014-10-21T14:43:27Z