Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Median of non-integer values

Hi Community,

I need to find the median of the Grade Column, which in this case will be 6+. I also have to apply certain filters, prior to  calculate the median. So I am using the expression:

Median
({<
[concat] = {"=rank(Count([concat]))=1"},
[Template]= {"=rank(Count(Template))=1"},
[Date]  ={">=$(=(date(AddMonths(Updated_Date,-12),'MM-DD-YYYY')))"}

>} Grade)
.

The problem with the above expression is that it doesn't work for non-integers. Is there a way wherein instead of taking Median of Grade, I will take Median of ID associated with the grade and than put the result in variable.

Than I can get the corresponding Grade using that variable.

The 2nd approach I think is to generate the RowNo dynamically in the set analysis and then use it to get the median Grade. But I am not sure how to generate the RowNo dynamically in setanalysis.

Need urgent help on this.

   

DateTemplateConcatGrade
2011-11-30 00:00:00 General IndustriesNet Sales6
2012-01-31 00:00:00 General IndustriesNet Sales7
2015-03-31 00:00:00 General IndustriesNet Sales6+
2014-03-31 00:00:00General IndustriesNet Sales6+
2015-03-31 00:00:00General IndustriesNet Sales6+
2015-03-31 00:00:00General IndustriesNet Sales6+
2014-08-31 00:00:00Middle Market EBITDA5
10 Replies
Anonymous
Not applicable
Author

Thanks a lot.