want to find median of days by time(cyclic group-quarter,month,week) dimension

[#1]

Hi Qlik folks,

I want to find the median of days by time(cyclic group-quarter,month,week) dimension.

I have developed the following formula but when the values of bar chart are broke by time dimension, getting weird values.

Any help will be appreciated please.

=median(NetWorkDays(aggr(min({$}ADate),ContractID),
aggr(max({$}ADate),ContractID)))

[Clever_Anjos]

Are you using a Cyclic Dimension right? Use it inside your AGGR´s, supposing your group is named "New Group":

=median(NetWorkDays(aggr(min({$}ADate),$(=GetCurrentField([New Group])),ContractID),

aggr(max({$}ADate),$(=GetCurrentField([New Group])),ContractID)))

[#3]

Thanks for your response Anjos. But my cyclic group expression do not have a name (I could not find to name it). I am using Qlikview version 11.20xxxxxSR12. Any help will be appreciated.

[Clever_Anjos · Accepted solution]

It´s the same name you can see into your Dimensions tab

[#5]

Thank you Anjos for your help.