Interval Match, Calss Functions

[#1]

Hi,

Any one can help with Interval Match and Class Functions...

which one i can use for Time and Numeric .....

Shall we over come Synthetic Keys by using Interval Match.....pls explain?

@Sub2u

[hic]

For intervalmatch, see IntervalMatch

The Class() function just groups numbers into classes. See e.g. Recipe for a Histogram. In this post I use the Round() function, but I could just as well have used Class().

HIC

[MarcoWedel]

Both work with numerical values, though using class with timestamps could require a bit formatting.

Class uses equally sized buckets while intervalmatch uses buckets of and size defined in a table.

hope this helps

regards

Marco

[#4]

so IntervalMatch -- Time, Class - Numeric

is it right sir?

[hic]

No.

Numbers, Dates and Times are all three numeric. All three can be used in both an Intervalmatch and a Class() function. See Data Types in QlikView.

The main difference between the Intervalmatch and the Class() is that Class() is a function, while Intervalmatch is a table transformation (and not a function).

HIC

[MarcoWedel]

No. Both functions work with both kinds of data.