Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
arvsuri007
Contributor II
Contributor II

Median of two separate columns - qlik sense

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:

AB
34567
5567
4568
7543
776

 

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?

Labels (1)
12 Replies
arvsuri007
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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