Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
revoori123
Contributor II
Contributor II

issue with median expression

I have  two fields  days,approvals+denials in that my set is [year type]= {'Current'} ,i want to calculate median for using that condition for

the two fields.an you please help me out this

4 Replies
YoussefBelloum
Champion
Champion

Hi,

try to attach your app or sample data

revoori123
Contributor II
Contributor II
Author

Data:

load * inline

[ Month,year,days, approvals

Jan,2017,9,8

Feb,201710,7

Apr,2016,23,15

Mar,2017,17,12

May,2017,5,3

jun,2017,1,0

jul,2017,34,25];

my formula sum(days)/sum(approvals),, i wnt median for the for that formula for year 2017

Anonymous
Not applicable

You want output for median formula is 12 or 17 Mar 2017?

Anil_Babu_Samineni

Are you trying to get 1.41 from given data as Median ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful