topic Re: class() explain them in qlikview in QlikView

class() explain them in qlikview

Mon, 05 Jan 2015 04:40:40 GMT

hi friends,

explain the class() function in qlikview

Re: class() explain them in qlikview

Anonymous — Mon, 05 Jan 2015 04:51:47 GMT

Hi medi,

The basic function of class() is to determine set of static intervals/limits as reqd.

You can give different lower and upper limits.

Thanks,

Vignesh

Re: class() explain them in qlikview

Anonymous — Mon, 05 Jan 2015 04:54:20 GMT

class function is used to get the band of a particular filed

Use the expression like

ex:

Age field consist the data like from 20 year to 90 years if u use the class filed to retrieve the age with band of 10

=Class(Age,10)

Output:

10<x<20

20<x<30

80<x<90

Re: class() explain them in qlikview

SunilChauhan — Mon, 05 Jan 2015 04:56:06 GMT

Class is alternative method to if to creates age or buckets. see below

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'

Re: class() explain them in qlikview

Mon, 05 Jan 2015 05:09:01 GMT

Class make buckets to better analyze the data. for Age expression in this chart I used:

=replace(class(Age,5),'<= x <',' to ')

tip: note that I used replace string function to convert the output 35 <= x < 40 to a more user friendly 35 to 40.

Re: class() explain them in qlikview

its_anandrjs — Mon, 05 Jan 2015 05:54:37 GMT

Hi,

About Class function check this post

http://community.qlik.com/message/680732#680732

Regards

Anand

Re: class() explain them in qlikview

Mon, 05 Jan 2015 06:00:28 GMT

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,10,'x',5 ) with var = 23 returns '15<=x<25'

Re: class() explain them in qlikview

Fri, 10 Apr 2015 05:52:19 GMT

Hi,

I am new to Qlikview, My requirement is:

I have a table Called age.

Age:

LOAD * INLINE [

Age

];

Now I want create a Bucket Using class Function in Listbox, Can please let me know. Step by step.

Requirement is like:

List Box:

Age

11-20 | 21-30 |31-40 | 41-50 | 51-60 Like this type i need.

Thanks,

Kumor

Re: class() explain them in qlikview

robert_mika — Fri, 10 Apr 2015 07:51:11 GMT

Listbox--->Field-->Expression

Type

=class(Age,10,'Age',11)

This is the closer you can get

You can change the expression to

=class(Age,10,'Age',10) to have bucket every 10 years

Age- is your field

10- is the bucket (every 10

'Age' is the text you can have between(you can change that to anything you like)

10- number where you want to start from