topic Re: issue with median expression in QlikView https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435330#M802415 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try to attach your app or sample data</P></BODY></HTML> Tue, 21 Nov 2017 16:31:07 GMT YoussefBelloum 2017-11-21T16:31:07Z issue with median expression https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435329#M802414 <HTML><HEAD></HEAD><BODY><P>I have&nbsp; two fields&nbsp; days,approvals+denials in that my set is [year type]= {'Current'} ,i want to calculate median for using that condition for</P><P>the two fields.an you please help me out this</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435329#M802414 revoori123 2020-11-25T16:16:04Z Re: issue with median expression https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435330#M802415 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try to attach your app or sample data</P></BODY></HTML> Tue, 21 Nov 2017 16:31:07 GMT https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435330#M802415 YoussefBelloum 2017-11-21T16:31:07Z Re: issue with median expression https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435331#M802416 <HTML><HEAD></HEAD><BODY><P>Data:</P><P>load * inline</P><P>[ Month,year,days, approvals</P><P>Jan,2017,9,8</P><P>Feb,201710,7</P><P>Apr,2016,23,15</P><P>Mar,2017,17,12</P><P>May,2017,5,3</P><P>jun,2017,1,0</P><P>jul,2017,34,25];</P><P></P><P></P><P></P><P>my formula sum(days)/sum(approvals),, i wnt median for the for that formula for year 2017</P></BODY></HTML> Wed, 22 Nov 2017 01:15:35 GMT https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435331#M802416 revoori123 2017-11-22T01:15:35Z Re: issue with median expression https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435332#M802417 <HTML><HEAD></HEAD><BODY><P>You want output for median formula is 12 or 17 Mar 2017?</P></BODY></HTML> Wed, 22 Nov 2017 03:46:37 GMT https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435332#M802417 Anonymous 2017-11-22T03:46:37Z Re: issue with median expression https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435333#M802418 <HTML><HEAD></HEAD><BODY><P>Are you trying to get 1.41 from given data as Median ??</P></BODY></HTML> Wed, 22 Nov 2017 04:01:16 GMT https://community.qlik.com/t5/QlikView/issue-with-median-expression/m-p/1435333#M802418 Anil_Babu_Samineni 2017-11-22T04:01:16Z