Getting equal sized bins in an expression

Mon, 06 Apr 2015 21:47:49 GMT

Hi All,

I have been struggling with the following: How do I go about getting the same number of observations in an expression.

Please see the attached qvw for an example. Basically, the fractile function is great for getting numbers binned into deciles. However, in this example I am looking to get them binned into deciles within an expression. The expression limits the number of observations that will appear, so the bins will no longer be deciles, but skewed (because score 1 and score 2 are very highly correlated). Anyone have any ideas how I could essentially force the bins to be of equal size? I've tried messing around with the aggr() function, but to no avail.

Thank you in advance

Jesse

topic Getting equal sized bins in an expression in QlikView

Getting equal sized bins in an expression