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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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
MVP
MVP

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