topic Calculating Adjusted Age aka Weeks On Floor in QlikView https://community.qlik.com/t5/QlikView/Calculating-Adjusted-Age-aka-Weeks-On-Floor/m-p/793545#M280485 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P></P><P>I need to create an adjusted weeks on floor metric.&nbsp; I currently have:</P><P></P><P><STRONG>(vMaxDate - Min(FIRST_ACTIVITY_DATE) / 7)</STRONG> which works fine.&nbsp; </P><P></P><P>However, the users want to exclude weeks where Product Units On Hand (in stock) &lt;= 0 (<STRONG>OH_Units</STRONG>).&nbsp; </P><P></P><P>Tried a few variations on below to no avail...</P><P></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG>(vMaxDate - Min(FIRST_ACTIVITY_DATE) / 7)</STRONG></SPAN><STRONG> </STRONG></P><P><STRONG>- </STRONG></P><P><STRONG>if(OH_Units) &lt;= 0, count([WEEK_ENDING_DATE]),0)</STRONG></P><P></P><P></P><P>Please help if you can!!</P></BODY></HTML> Wed, 25 Mar 2015 19:21:44 GMT 2015-03-25T19:21:44Z Calculating Adjusted Age aka Weeks On Floor https://community.qlik.com/t5/QlikView/Calculating-Adjusted-Age-aka-Weeks-On-Floor/m-p/793545#M280485 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P></P><P>I need to create an adjusted weeks on floor metric.&nbsp; I currently have:</P><P></P><P><STRONG>(vMaxDate - Min(FIRST_ACTIVITY_DATE) / 7)</STRONG> which works fine.&nbsp; </P><P></P><P>However, the users want to exclude weeks where Product Units On Hand (in stock) &lt;= 0 (<STRONG>OH_Units</STRONG>).&nbsp; </P><P></P><P>Tried a few variations on below to no avail...</P><P></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG>(vMaxDate - Min(FIRST_ACTIVITY_DATE) / 7)</STRONG></SPAN><STRONG> </STRONG></P><P><STRONG>- </STRONG></P><P><STRONG>if(OH_Units) &lt;= 0, count([WEEK_ENDING_DATE]),0)</STRONG></P><P></P><P></P><P>Please help if you can!!</P></BODY></HTML> Wed, 25 Mar 2015 19:21:44 GMT https://community.qlik.com/t5/QlikView/Calculating-Adjusted-Age-aka-Weeks-On-Floor/m-p/793545#M280485 2015-03-25T19:21:44Z