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?

[arvsuri007]

Thanks Sunny,

This one is not working. Do you have any such calculation for two variables (as an example variables contain values of both column A & B)?

[sunny_talwar]

I don't have an example already created...

[arvsuri007]

Thanks Sunny,

It almost did the part but I have to move to different data modelling due to my calculations.

Your help is justifiable 🙂

Regards,

Arvind