topic Median Example Required in QlikView https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336955#M494204 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have a table with rows (12 Rows) Apr 2010, May 2010, Jun 2010 ... (And so on for 12 Financial Months)</P><P></P><P>Each row has a total count of =Sum(ActivityCount) for that Financial Year Month</P><P></P><P>What Im after if the median for each month (The median is based on the previous 12 months from the month as shown in the table row)</P><P></P><P>Has anyone got any examples that would be helpfull</P><P></P><P>Thanks</P><P></P><P>MArtin</P><P></P></BODY></HTML> Wed, 04 Apr 2012 12:55:01 GMT 2012-04-04T12:55:01Z Median Example Required https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336955#M494204 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have a table with rows (12 Rows) Apr 2010, May 2010, Jun 2010 ... (And so on for 12 Financial Months)</P><P></P><P>Each row has a total count of =Sum(ActivityCount) for that Financial Year Month</P><P></P><P>What Im after if the median for each month (The median is based on the previous 12 months from the month as shown in the table row)</P><P></P><P>Has anyone got any examples that would be helpfull</P><P></P><P>Thanks</P><P></P><P>MArtin</P><P></P></BODY></HTML> Wed, 04 Apr 2012 12:55:01 GMT https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336955#M494204 2012-04-04T12:55:01Z Median Example Required https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336956#M494205 <HTML><HEAD></HEAD><BODY><P> Or even if this is possible to do..</P><P></P><P>Thanks</P></BODY></HTML> Thu, 05 Apr 2012 13:10:46 GMT https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336956#M494205 2012-04-05T13:10:46Z Median Example Required https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336957#M494206 <HTML><HEAD></HEAD><BODY><P>Can you post your app?</P></BODY></HTML> Thu, 05 Apr 2012 13:39:53 GMT https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336957#M494206 Jason_Michaelides 2012-04-05T13:39:53Z Median Example Required https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336958#M494207 <HTML><HEAD></HEAD><BODY><P> Hi there...</P><P></P><P>Thanks. I'm unable to post the app as it confidential. But what i may do over easter is recreate what im after at home on my local copy with dummy data for 2 years, and post this if you dont mind</P><P></P><P>I feel i ve tried all kinds and keep hitting a brick wall.</P><P></P><P>Thanks for your reply btw</P><P></P><P>Martin</P></BODY></HTML> Thu, 05 Apr 2012 14:57:19 GMT https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336958#M494207 2012-04-05T14:57:19Z Median Example Required https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336959#M494208 <HTML><HEAD></HEAD><BODY><P>There's pretty much always a way with QlikView - just a case of finding it!!</P></BODY></HTML> Thu, 05 Apr 2012 16:30:05 GMT https://community.qlik.com/t5/QlikView/Median-Example-Required/m-p/336959#M494208 Jason_Michaelides 2012-04-05T16:30:05Z