topic Re: Stuck with uneven intervel databuckets creation!!! in QlikView

Stuck with uneven intervel databuckets creation!!!

hariprasadqv — Thu, 18 Jun 2015 04:05:38 GMT

Hi All,

My data is having a field called quantity,in which i have to create uneven intervel buckets. I know that we can use CLASS() for creating data buckets in even intervales. But I have to create uneven intervels.

Qauntity values are in between 1000 to 18999.

I have to create bucket 1 in between 1000-7000

bucket 2 in between 7000-15000

bucket 3 in between 15000-18999

Thank you

Re: Stuck with uneven intervel databuckets creation!!!

Thu, 18 Jun 2015 04:49:12 GMT

Try nested if condition or do it at script level, don't think class function would be useful in your case.

Re: Stuck with uneven intervel databuckets creation!!!

hariprasadqv — Thu, 18 Jun 2015 04:50:04 GMT

Thank you.

Re: Stuck with uneven intervel databuckets creation!!!

jagan — Thu, 18 Jun 2015 05:09:45 GMT

Hi,

Try like this in script

LOAD

If(Qauntity >= 15000 AND Qauntity < 18999, '15000-18999',

If(Qauntity >=7000 AND Qauntity < 15000, '7000-15000',

If(Qauntity >= 1000 AND Qauntity < 7000, '1000-7000', 'N/A'))) AS Bucket

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Stuck with uneven intervel databuckets creation!!!

sujeetsingh — Thu, 18 Jun 2015 05:13:44 GMT

You can try nested if to resolve this

,if(Qauntity>=1000 and Qauntity <=18999,Bucket1,If(Qauntity >=1000 and Qauntity<= 7000,Bucket2)).....as Buckets

Re: Stuck with uneven intervel databuckets creation!!!

hariprasadqv — Thu, 18 Jun 2015 05:14:15 GMT

Thank you Jagan.

Re: Stuck with uneven intervel databuckets creation!!!

MarcoWedel — Thu, 18 Jun 2015 06:08:06 GMT

Custom Filter(unusual range)

Hope this helps

Regards

Marco

Re: Stuck with uneven intervel databuckets creation!!!

jagan — Thu, 18 Jun 2015 06:13:17 GMT

Hi Hari,

If you got the answer for this, please close this thread.

Regards,

Jagan.

Re: Stuck with uneven intervel databuckets creation!!!

hariprasadqv — Thu, 18 Jun 2015 06:20:01 GMT

Thank you jagan.