Discussion Board for collaboration related to QlikView App Development.
Hi Qlik folks,
I have a table of values which I aim to dividing it into Quartiles as evenly as possible. The expression I use in the chart is:
IF( Value <= Fractile (TOTAL Value, 0.25),
IF( Value <= Fractile (TOTAL Value, 0.50),
IF( Value <= Fractile (TOTAL Value, 0.75),
This does the job, however the distribution of values is not even as I have equal values which my expression tends to put them all in one quartile.
For the purpose of the analysis, I need the quartiles to have equal or at least near equal number of values. How can I achieve this?
I think if you want to get a rather equal number of values within the buckets you will rather need a rank-function, maybe something like that:
ceil(rank(total Value) / (count(total Value) / 4))
The function I use to good effect is:
CEIL(RANK([Value]), 4) / COUNT(TOTAL [Value]) * 4)
The key being the RANK(Value, "Mode 4"): RANK Documentation