Using the Fractile() function to generate quartiles

Qlik Sense provides a host of statistical functions that can be put to effective use based on requirements in user reports. At a recent implementation, one of the requirements that popped out was to divide the data values into four quartiles. Quartiles are equivalent to percentiles that divide the data into four groups. The first quartile is determined by every value that is equal to and less than the twenty-fifth percentile. The second quartile is determined by every value that is between the twenty-fifth and the fiftieth percentile. The third quartile is determined by every value that is between the fiftieth and the seventy-fifth percentile. The fourth quartile will be all the data values above and beyond the value of the seventy-fifth percentile. In order to generate quartiles in Qlik Sense, we make use of the Fractile() function. The following recipe explains the process.

Getting ready

For the sake of this recipe, we create a hypothetical...