Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Evgeniya
Contributor III
Contributor III

Rolling median

Hi All!

Please help me to resolve some problem with calculation median.

I have table with two coloms: DateTime,Value.

I need make line chart with rolling median for last 24 hours. 

I use formula:  Median(Aggr(Above(sum(Value),0,1440),DateTime))

But It doesn't  work. I  get result such us if I use sum(Value).

Anybody know how resolve this issue?

Labels (2)
1 Reply
Brett_Bleess
Former Employee
Former Employee

Only thing I have is the following:

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

Feel free to back that URL up to the Qlik-Design-Blog/ level and search yourself though, there are hundreds of posts out there and most have very helpful examples etc., so you may be able to find what you need there or another idea that will work.  Sorry I am not more help to you.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.