Quartile / Fractile

[#1]

Hi Every one,

I am trying to calculate Quatile, I am not able to get to it. Please help me. The requirement is as under.

Requirement:

1. In Guage want to get 4 fixed segment size.

2. On Selction of Student ID gauge should show niddle for correct Quartile

3. The calculation of Quartile is correct in table but when I make selection, calculation changes and Guage is not showing correctly, It show Values one

Please see attached Qlikview Document with sample data in Excel and Excel Quartile Calculation

Thank you in Advance

[lironbaram · Accepted solution]

hi attach is your file

fixed the expression with set analysis on the toatl side so will still count all students

[#3]

Thank you Very Much.