topic Aging Report based on min Reciept Date in QlikView https://community.qlik.com/t5/QlikView/Aging-Report-based-on-min-Reciept-Date/m-p/193113#M54520 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>i'm working on creating an aging inventory report for items with a receipt date greater than 30 days.</P><P>I've started with this if statement,</P><P>sum (if(Today()-Receipt Date&gt;30, Inventory))</P><P>However my challenge presents itself in the receipt date because an item has several receipt dates(in and outbound). I need the first date for which there was an order. i can get that seperately by using this set analysis.</P><P></P><P></P><P>min({$&lt;Order-={0}&gt;} date(Receipt Date))</P><P>Is there anyway to combine the if statement and set analysis? Or should i go a different route?</P><P>Help is greatly appreciated!</P><P>Thanks,</P><BR /><BR /></BODY></HTML> Thu, 17 Jun 2010 18:43:53 GMT 2010-06-17T18:43:53Z Aging Report based on min Reciept Date https://community.qlik.com/t5/QlikView/Aging-Report-based-on-min-Reciept-Date/m-p/193113#M54520 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>i'm working on creating an aging inventory report for items with a receipt date greater than 30 days.</P><P>I've started with this if statement,</P><P>sum (if(Today()-Receipt Date&gt;30, Inventory))</P><P>However my challenge presents itself in the receipt date because an item has several receipt dates(in and outbound). I need the first date for which there was an order. i can get that seperately by using this set analysis.</P><P></P><P></P><P>min({$&lt;Order-={0}&gt;} date(Receipt Date))</P><P>Is there anyway to combine the if statement and set analysis? Or should i go a different route?</P><P>Help is greatly appreciated!</P><P>Thanks,</P><BR /><BR /></BODY></HTML> Thu, 17 Jun 2010 18:43:53 GMT https://community.qlik.com/t5/QlikView/Aging-Report-based-on-min-Reciept-Date/m-p/193113#M54520 2010-06-17T18:43:53Z