topic Rolling median in QlikView

Rolling median

Evgeniya — Sat, 16 Nov 2024 20:20:23 GMT

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?

Re: Rolling median

Brett_Bleess — Thu, 22 Aug 2019 16:09:24 GMT

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