Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Median Example Required

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

4 Replies
Not applicable
Author

Or even if this is possible to do..

Thanks

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Can you post your app?

Not applicable
Author

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

Jason_Michaelides
Luminary Alumni
Luminary Alumni

There's pretty much always a way with QlikView - just a case of finding it!!