Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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