Median of two separate columns - qlik sense

[arvsuri007]

Hi all,

I need to get median between two columns and end result should be combined median of two columns A & B as shown below:

A	B
34	567
55	67
45	68
75	43
7	76

End result should be 61.0. Please help.

I am facing almost the same scenario but the difference is I need to create those columns (as measures) and then do the median?

[sunny_talwar]

Can you explain how are you arriving at 61 based on the data provided above? Median of A = 45 and Median of B = 68... right? How do you get to 61 from here?

[arvsuri007]

Hi Sunny,

Sorry for late response,

I need a calculation so that it can calculate both the columns as combined one like below

A	34
A	55
A	45
A	75
A	7
B	567
B	67
B	68
B	43
B	76
Median	61

[sunny_talwar]

And you need this output in a KPI object?

[arvsuri007]

Correct.

[sunny_talwar]

Try this in a KPI object

=RangeFractile(0.5, $(=Concat(A, ',') & ',' & Concat(B, ',')))

[arvsuri007]

Thanks 🙂 

Scenario here is ; I have calculated columns based on multiple conditions and if i store them as variable then what should be the calc.

Regards,

Arvind

[sunny_talwar]

Not sure I follow.

[arvsuri007]

Hi Sunny,

See above columns (basically measures) are based on certain calculation ( includes functions; getfieldselection,getselectedcount&median). And if I am using your calculation to 'concat' then need to entertain that measure in place of columns A & B which shows me an error. So i created a variables for both measures, need to know if we can concat variables as per your calculation.

Regards,

Arvind

[sunny_talwar · Accepted solution]

Add Aggr() with your dimensions within Concat

Concat(Aggr(YourExpression, YourChartDimensions), ',')