How to Calculate Median

[#1]

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

[Anonymous]

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 )

[#3]

Thanks Johannes ,

For your quick reply . Thanks for your help.

Regards,

Chakravarthy.

[#4]

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