topic Re: Expression to calculate Rows Median in straight chart in QlikView

Expression to calculate Rows Median in straight chart

nayanpatel — Mon, 10 Apr 2017 04:35:27 GMT

Hi Friends,

I wanted to calculate Median of Rows in Straight chart. below given is the expression I am using. However, this expression giving me expression total. Also there is no selection available in Straight chart to calculate "Median of Rows". Please help how to calculate Median.

Exp=Median(Aggr(Only({<FlagDate = {1}>} [E2EDays]),id))

Thank you.

Nayan

Re: Expression to calculate Rows Median in straight chart

gerry_hdm — Mon, 10 Apr 2017 04:52:42 GMT

Hello

you can the Median setting in the diagram

Re: Expression to calculate Rows Median in straight chart

Anonymous — Mon, 10 Apr 2017 05:01:40 GMT

try something like

Median({<FlagDate = {1}>}Aggr(Only({<FlagDate = {1}>} [E2EDays]),id))

Re: Expression to calculate Rows Median in straight chart

nayanpatel — Mon, 10 Apr 2017 05:12:00 GMT

Hi Shiva, Thanks for reply.

Both expressions results same output

Re: Expression to calculate Rows Median in straight chart

Anonymous — Mon, 10 Apr 2017 05:32:47 GMT

if possible can you share a sample .qvw?