Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a table with rows (12 Rows) Apr 2010, May 2010, Jun 2010 ... (And so on for 12 Financial Months)
Each row has a total count of =Sum(ActivityCount) for that Financial Year Month
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)
Has anyone got any examples that would be helpfull
Thanks
MArtin
Or even if this is possible to do..
Thanks
Can you post your app?
Hi there...
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
I feel i ve tried all kinds and keep hitting a brick wall.
Thanks for your reply btw
Martin
There's pretty much always a way with QlikView - just a case of finding it!!