topic Median Calculation in QlikView https://community.qlik.com/t5/QlikView/Median-Calculation/m-p/623433#M1108146 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> I had a simple rquirement, but not getting the solution. May be missing something..<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P><STRONG>Scenario</STRONG>:</P><P>There is 3 fields in one table.(Fields: Firm_Name, Time_Period, Hours). I want to calculate the Median of the Hours and correponding Firm_Name.</P><P>Dimension : Time_Period</P><P>Expressions: Median, Firm_Name( corresponding to the Median value)</P><P></P><P><STRONG>Functionality</STRONG>:</P><P>If the count is Odd number then there is no issue.--- Median(Hours)</P><P>If the count is Even then, the median value doesn't match to any existing Hours value. So I am not able to display the Firm_Name. So I want to&nbsp; dispaly the middle 2 values and its correposnding Firm_Name.</P><P></P><P><STRONG>Ex</STRONG>: 6,9,2,5,10,7 (After sorting... 2,5,6,7,9,10)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Here I want to display the values 6 &amp; 7 and its coresponding Firm_Name.</P><P></P><P>Thanks in advance...</P></BODY></HTML> Wed, 26 Mar 2014 08:19:19 GMT PradeepReddy 2014-03-26T08:19:19Z Median Calculation https://community.qlik.com/t5/QlikView/Median-Calculation/m-p/623433#M1108146 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> I had a simple rquirement, but not getting the solution. May be missing something..<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P><STRONG>Scenario</STRONG>:</P><P>There is 3 fields in one table.(Fields: Firm_Name, Time_Period, Hours). I want to calculate the Median of the Hours and correponding Firm_Name.</P><P>Dimension : Time_Period</P><P>Expressions: Median, Firm_Name( corresponding to the Median value)</P><P></P><P><STRONG>Functionality</STRONG>:</P><P>If the count is Odd number then there is no issue.--- Median(Hours)</P><P>If the count is Even then, the median value doesn't match to any existing Hours value. So I am not able to display the Firm_Name. So I want to&nbsp; dispaly the middle 2 values and its correposnding Firm_Name.</P><P></P><P><STRONG>Ex</STRONG>: 6,9,2,5,10,7 (After sorting... 2,5,6,7,9,10)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Here I want to display the values 6 &amp; 7 and its coresponding Firm_Name.</P><P></P><P>Thanks in advance...</P></BODY></HTML> Wed, 26 Mar 2014 08:19:19 GMT https://community.qlik.com/t5/QlikView/Median-Calculation/m-p/623433#M1108146 PradeepReddy 2014-03-26T08:19:19Z