Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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