Fractile clear explanation

[qlikapple]

Hi all,

Can anyone  please explain what is the expression meaning

Fractile(Aggr(NODISTINCT Sum(Score) / count(ID),ID), 0.5)

[qlikapple]

can anyone please give reply

[jonathandienst]

The expression calculates the 50% fractile (aka the median) of the average score by ID. 

[qlikapple]

Hi Jonty

can we use median function for this, if we can use median function, can you please tell me how to write this

[jonathandienst · Accepted solution]

Median(Aggr(NODISTINCT Sum(Score) / count(ID), ID))