topic Re: Interval Match, Calss Functions in QlikView

Interval Match, Calss Functions

Sun, 25 Jan 2015 18:55:51 GMT

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

Re: Interval Match, Calss Functions

hic — Sun, 25 Jan 2015 20:45:45 GMT

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

Re: Interval Match, Calss Functions

MarcoWedel — Mon, 26 Jan 2015 00:11:31 GMT

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

Re: Interval Match, Calss Functions

Mon, 26 Jan 2015 05:23:02 GMT

so IntervalMatch -- Time, Class - Numeric

is it right sir?

Re: Interval Match, Calss Functions

hic — Mon, 26 Jan 2015 07:19:27 GMT

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

Re: Interval Match, Calss Functions

MarcoWedel — Mon, 26 Jan 2015 07:20:47 GMT

No. Both functions work with both kinds of data.