topic Median Calculation in QlikView

Median Calculation

sunitha_chellaiah — Mon, 22 Jul 2019 05:27:30 GMT

Hi All,

I want to calculate median for calculated measure. I tried but getting wrong value. Hope you all will help me in this issue.

I have attached example data to try.

Required output : Median of (% Gross deviation) .... column M in excel file

caluculation for (% Gross deviation) used in qlikview : [Absolute deviation (days)]/[IDA estimated lead time (days)] (note: it is not a field , it is a column used in measure)

caluculation for [Absolute deviation (days)] : [Actual Lead Time (Days)]-[IDA estimated lead time (days)] (note: it is not a field , it is a column used in measure)

calculation for [Actual Lead Time (Days)] : If(len([Shipment delivery date])>0 and len([Shipment departure date ])>0,
[Shipment delivery date]-[Shipment departure date],' ')

Note: I want to show median of ( % Gross deviation) against year-month of (Shipment delivery date) in a bar chart

Thanks.

Re: Median Calculation

sunny_talwar — Mon, 22 Jul 2019 12:50:34 GMT

Have you already tried doing this using Median(Aggr([Absolute deviation (days)]/[IDA estimated lead time (days)] , your dimensions))... here make sure that you are using the whole expression instead of the labels of your expressions?

Re: Median Calculation

Brett_Bleess — Wed, 14 Aug 2019 16:53:06 GMT

Sunitha, did Sunny's post help you? If so, please be sure to click the Accept as Solution button on his post to give him credit. If you figured it out otherwise, please consider posting what you did for others. You can mark that as the solution at that point as well.

Regards,
Brett