# 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
Did you mean:
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:

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

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)
• ### Median of two separate columns

1 Solution

Accepted Solutions
MVP

``Concat(Aggr(YourExpression, YourChartDimensions), ',')``
12 Replies
MVP

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?

Contributor II
Author

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
MVP

And you need this output in a KPI object?

Contributor II
Author

Correct.

MVP

Try this in a KPI object

``=RangeFractile(0.5, \$(=Concat(A, ',') & ',' & Concat(B, ',')))``
Contributor II
Author

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

MVP

Not sure I follow.

Contributor II
Author

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

MVP

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