Issue calculating quintiles (fractile function)

[michael_andrews]

I'm getting some wrong numbers trying to calculate quintiles. Basically I have 5 columns 0%-20%, 20%-40%, 40%-60%, etc.

And I'm trying to put the counts where ExamScores fall in those quintiles like so.

Count({<ExamAggExamScoreRaw = {"< $(=Fractile(ExamAggExamScoreRaw,0.20))"}>} DISTINCT ExamID)

I'm getting some bad counts so I was trying to just see what it was getting for the fractile of .2, but when I put

Fractile(ExamAggExamScoreRaw,0.20) to output data, it gives me an error, what am I missing?

[hector_munoz]

Hi Michael,

In which object are you trying to do that? Have you any dimension?

Regards,
H

[michael_andrews]

The ExamAggExamScoreRaw field is the Score of the exam. Basically what I'm trying to figure out is what number qlik is getting for the 20% cut off, when I do the fractile of that exam score