topic Liquidation Curve - Days Past Due in QlikView https://community.qlik.com/t5/QlikView/Liquidation-Curve-Days-Past-Due/m-p/1045090#M351366 <HTML><HEAD></HEAD><BODY><P>Good afternoon,</P><P></P><P>I am having a bit of a problem trying to figure out how to put create a liquidation curve. Basically what I want is an x axis with Days Past Due from 1 to 180, a y axis with % paid of total. It should look like this:<IMG __jive_id="114799" alt="example.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114799_example.JPG" style="height: auto;" /></P><P>I want to group by deposit month, so if I have January deposits, once all have come due (all come due in 30 days max) I want to start calculating CAPITAL OUT/CAPITAL IN. I have created a DaysPastDue variable to use as Dimension but am have trouble with how to create an expression that would do this.</P><P>I have a DUEDATE, CAPITAL OUT, PAYMENT IN variable which will obviously be of use...could anyone give me a hand?</P><P></P><P>Many thanks!</P><P></P><P>Please, any help appreciated!</P></BODY></HTML> Tue, 16 Feb 2016 12:41:31 GMT 2016-02-16T12:41:31Z Liquidation Curve - Days Past Due https://community.qlik.com/t5/QlikView/Liquidation-Curve-Days-Past-Due/m-p/1045090#M351366 <HTML><HEAD></HEAD><BODY><P>Good afternoon,</P><P></P><P>I am having a bit of a problem trying to figure out how to put create a liquidation curve. Basically what I want is an x axis with Days Past Due from 1 to 180, a y axis with % paid of total. It should look like this:<IMG __jive_id="114799" alt="example.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114799_example.JPG" style="height: auto;" /></P><P>I want to group by deposit month, so if I have January deposits, once all have come due (all come due in 30 days max) I want to start calculating CAPITAL OUT/CAPITAL IN. I have created a DaysPastDue variable to use as Dimension but am have trouble with how to create an expression that would do this.</P><P>I have a DUEDATE, CAPITAL OUT, PAYMENT IN variable which will obviously be of use...could anyone give me a hand?</P><P></P><P>Many thanks!</P><P></P><P>Please, any help appreciated!</P></BODY></HTML> Tue, 16 Feb 2016 12:41:31 GMT https://community.qlik.com/t5/QlikView/Liquidation-Curve-Days-Past-Due/m-p/1045090#M351366 2016-02-16T12:41:31Z