Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting equal sized bins in an expression

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

0 Replies