Weighted Median in Qlik Sense

[grakhovski]

Hey all,

I need to calculate the WTDPERC (weighted median) in Qlik for the following expression:

WTDPERC(([COMP5ACT] - [COMP4ACT]) / [COMP1], [SMI_CODE], 50, 0).

I would be grateful for any suggestions regarding a solution.

Thank you!

[Or]

No idea what WTDPERC is and Google doesn't seem to know either. Could you perhaps provide sample data and expected results, or some other means of better understanding what you're trying to achieve?

[grakhovski]

Median of the expression ([COMP5ACT] - [COMP4ACT]) / [COMP1] weighted by SMI_CODE column 

[marcus_sommer]

Maybe something like this:

median(aggr(avg(([COMP5ACT] - [COMP4ACT]) / [COMP1]), SMI_CODE))