Maybe Class() could be the thing you are looking for?
Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.
If you want to use automatic same-length intervals, you can use class() function as a calculated dimension. This is an example:
This will create automatic 3-month intervals from number_of_months field.
Otherwise, if you like to specify your own intervals, you have to use intervalmatch clause in script, to connect your intervals to number of month field. Usage is like this:
Load id, number_of_months from Whatever;
LOAD * INLINE [
from, to, name
0, 50, 0-50
51, 100, 51-100
101, 10000, 101 and more
left join (table1)
Than you will have your own intervals named 0-50, 51-100 and 101 and more connected to table with number of months. When doing intervalmatch join, you need to have all needed field already loaded in qlikview.
Hope this helpes:)