How to use INTERVALMATCH with DUAL Field

Wed, 12 Jan 2011 11:57:27 GMT

Hi Guys,

I have a table named TeamTrack, which contains a field named "DaysHandle"

That field contains several discrete values.

I need to associate the values in that field by categories, so I create the table "Categories" which contains the ranges (categories) I need, with a min and max for each range.

Now I intend to use IntervalMatch to associate the discrete values in field "DaysHandle" from table TeamTrack with the ranges (Categories) in table Categories.

It seems to be working, but I don't know how to show also the field DaysHandleCategory (it is dual, but I do not how to deal with it).

Thanks in advance,

Aldo.

TeamTrack20:

LOAD * INLINE [

DaysHandle, Field2, Field3

2, a, f

7, b, g

22, c, h

50, d, i

3, e, j

];

Categories:

Load

dual (CategoryName, MinValue) as DaysHandleCategory,

MinValue,

MaxValue

inline [

CategoryName, MinValue, MaxValue

'0-5', 0, 5

'6-20', 6, 20,

'21-40', 21, 40,

'40 and above', 41

];

intervalmatch(DaysHandle) load MinValue, MaxValue resident Categories;

drop table Categories;

topic How to use INTERVALMATCH with DUAL Field in QlikView

How to use INTERVALMATCH with DUAL Field