Making Buckets for the following using class or intervalmatch ?

Anonymous — Mon, 10 Sep 2012 14:41:09 GMT

Hi ,

Here year is depicted as 0.5, 0.75 ,1 ,1.25.....so on till 57 years.

I want to build a bucket where values that fall between 0 to 1yrs should fall in the bucket 1. and 1.25 to 1.50 should fall in the bucket 1.5 ..1.51 and 2 should fall in the bucket 2..so on.

I know this can be done using if condition followed by creating a mapping table. But this method is cumbersome ..as I have to write if condition till 59 years.

Is there a easier way of doing this ( I'm sure it can be done using interval match or class funtion )

And how to convert the value 1.25 to 1 year 3 months .

Balraj

Re: Making Buckets for the following using class or intervalmatch ?

whiteline — Mon, 10 Sep 2012 18:18:18 GMT

Hi.

Class function gives you an equidistant buckets so this is not the case.

Create a table with boundaries and use interval match.

topic Making Buckets for the following using class or intervalmatch ? in QlikView

Making Buckets for the following using class or intervalmatch ?

Re: Making Buckets for the following using class or intervalmatch ?