Create a intervall from single column

[beck_bakytbek]

Hi Folsk,

i got a question: is that possible to create the intervall from single column: for instance

I have Field: Overdue

Overdue

1

5

16

-20

and i want create the invervall: 

Overdue:

Under 0,

Between 1 and 10

Between 10 and 20

i know, i can solve this with the help of if..then ()-function. But would like to know, wether is that possible to create the intervall from single column with using of function: IF... Then.

Thanks a lot

Bek

[QFabian]

Hi @beck_bakytbek , one option is create the table with the intervals, and then associate your field to that ranges, something like this,just replace Overdue table with your table with Overdue field :

Overdue:
load * INLINE [
OverdueField
1
5
16
-20
];

OverdueInterval:
load * INLINE [
Min, Max, OverdueInterval
-999, 0, Under 0
1, 10, Between 1 and 10
11, 20, Between 11 and 20
];

Inner Join IntervalMatch ( OverdueField )

LOAD Min, Max
Resident OverdueInterval;

[beck_bakytbek]

Hi Fabian, first of all, thanks a lot for your help and time, 

it does sound great, i will try and report you if i solve my issue by using of your suggestion