topic How to Calculate Median in QlikView

How to Calculate Median

Wed, 15 Dec 2010 07:10:26 GMT

Hi All,

I have the columns Age and Profile . I have to calculate the Median Age for Profile as Dimension.

Help me to Calculate the Median(Age) in QlikView .

Thanks in Advance ....

Regards,

Chakravathy

How to Calculate Median

Anonymous — Wed, 15 Dec 2010 07:13:17 GMT

Use the median() function:

median ( [{set_expression}] [ total [<fld {,fld}>] ] expression )
Returns the aggregated median of expression iterated over the chart dimension(s).

This function has the same limitations for nested aggregation as the avg function. The median function supports sets and the total qualifier in the same way as the avgfunction.

Examples:
median( X )

median( X*Y/3 )

median( total X )

median( total <Group> Price )

How to Calculate Median

Wed, 15 Dec 2010 07:24:21 GMT

Thanks Johannes ,

For your quick reply . Thanks for your help.

Regards,

Chakravarthy.

Re: How to Calculate Median

Fri, 26 Sep 2014 23:26:39 GMT

Are there any resources I can turn to that will explain how to unpack and apply the code in this function?

Specifically,( [{set_expression}] [ total [<fld {,fld}>] ] expression )

Best,

Jens