topic max date per metric - with differing max dates in QlikView https://community.qlik.com/t5/QlikView/max-date-per-metric-with-differing-max-dates/m-p/521094#M1131424 <HTML><HEAD></HEAD><BODY><P>Hi I have a table of metrics - some have different max dates.</P><P></P><P>For my report I wish to show the most recent data for each metric</P><P></P><P>so for example some may be for Aug 13 and others may be for Oct 13.</P><P></P><P>My formulas is -</P><P>sum(numerator)/sum (denomenator)</P><P></P><P>Im also needing for each metiric to show a 15 previous month chart based on the max date</P><P></P><P>Pls Help</P><P></P><P><BR /> </P></BODY></HTML> Wed, 13 Nov 2013 16:22:14 GMT 2013-11-13T16:22:14Z max date per metric - with differing max dates https://community.qlik.com/t5/QlikView/max-date-per-metric-with-differing-max-dates/m-p/521094#M1131424 <HTML><HEAD></HEAD><BODY><P>Hi I have a table of metrics - some have different max dates.</P><P></P><P>For my report I wish to show the most recent data for each metric</P><P></P><P>so for example some may be for Aug 13 and others may be for Oct 13.</P><P></P><P>My formulas is -</P><P>sum(numerator)/sum (denomenator)</P><P></P><P>Im also needing for each metiric to show a 15 previous month chart based on the max date</P><P></P><P>Pls Help</P><P></P><P><BR /> </P></BODY></HTML> Wed, 13 Nov 2013 16:22:14 GMT https://community.qlik.com/t5/QlikView/max-date-per-metric-with-differing-max-dates/m-p/521094#M1131424 2013-11-13T16:22:14Z Re: max date per metric - with differing max dates https://community.qlik.com/t5/QlikView/max-date-per-metric-with-differing-max-dates/m-p/521095#M1131425 <HTML><HEAD></HEAD><BODY><P>Anyone able to help with this?</P></BODY></HTML> Thu, 14 Nov 2013 09:06:30 GMT https://community.qlik.com/t5/QlikView/max-date-per-metric-with-differing-max-dates/m-p/521095#M1131425 2013-11-14T09:06:30Z