topic Re: Fractile Reverse in QlikView

Fractile Reverse

amars — Mon, 09 Sep 2013 07:31:16 GMT

Hi all,

By above name to the thread, what I mean is, by using Fractile Function we can find out 50th Percentile for a given list of values.

I wish to find out the Percentile value for a score, within a given list of Scores.

Is there any function to do that?

Thanks in advance.

Amar

Re: Fractile Reverse

Gysbert_Wassenaar — Mon, 09 Sep 2013 07:52:02 GMT

Something like this perhaps: count({<Score={'<=$(vScoreValue)'}>} Score)/count(total Score)

Use a variable vScoreValue to store the score value of which you want the fractile. Then count all scores that are lower or equal to that value and divide that by the total count of scores.

Re: Fractile Reverse

amars — Mon, 09 Sep 2013 08:48:52 GMT

If I have to calculate manually, it is becoming quite complex, the formula is like

i.e.

= ( Max( Total Rank) - UpperboundValue of (Individual Score) ) / Max( Total Rank)

Fore me score is again a calculated value , thus it is becoming quite complex

=((Max(Total Aggr(Rank(Total (ScoreFormulae),3), Dimensions)) - Num(Rank(Total ScoreFormulae,3)))

/Max(Total Aggr(Rank(Total (ScoreFormulae),3), Dimensions))

The other problem is I wish to calculate it at script level otherwise. Since the value is fixed.

Can you suggest something.

Thanks a lot.