topic Re: Buckets in QlikView

Buckets

abhaysingh — Thu, 07 Aug 2014 08:55:26 GMT

I want to make buckets and wants to use it as dimension.

attching picture pls suggest me.

want to use these Buckets as a dimension

Re: Buckets

Gysbert_Wassenaar — Thu, 07 Aug 2014 08:59:20 GMT

See this blog post: Buckets

Re: Buckets

kaushiknsolanki — Thu, 07 Aug 2014 09:00:58 GMT

HI,

Use the "Class" function for the same.

Regards,

Kaushik Solanki

Re: Buckets

ashfaq_haseeb — Thu, 07 Aug 2014 09:03:49 GMT

Hi use class() function

Regards

ASHFAQ

Re: Buckets

deepakqlikview_123 — Thu, 07 Aug 2014 09:07:24 GMT

Hi Abhay,

In your case your range values are not constant so I would suggest you to use If else .

Please refer link provided by gwassenaar

Thanks,

Deepak

Re: Buckets

fkeuroglian — Thu, 07 Aug 2014 12:53:19 GMT

Use class function

class( var,10 )

get bucket of 10 to 10

Fernando

Re: Buckets

its_anandrjs — Thu, 07 Aug 2014 13:02:40 GMT

You have to use Class Function and for help see its syntax which is from help and also the URL that Gysbert Wassenaar you can follow that one also

class(expression, interval [ , label [ , offset ]])

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'