Median of two column - 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.

Regards,

Arvind

[arvsuri007]

Can anyone help or give me any suggestion on how to do this?