Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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