topic Re: Class function in QlikView

Class function

vikasmahajan — Thu, 18 Jul 2013 03:40:03 GMT

Hiii,

Good Morning ,

Can any one please explain me how class function is working in qlikview with sample demo.

Thanks

Vikas

Re: Class function

nagaiank — Thu, 18 Jul 2013 04:13:02 GMT

Qlikview Reference Manual has the following information.

Re: Class function

Siva_Sankar — Thu, 18 Jul 2013 04:14:50 GMT

hi, syntax: 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

Re: Class function

tresB — Thu, 18 Jul 2013 04:20:03 GMT

For more explanation and examples, have a look http://www.quickqlearqool.nl/?p=725

Edit: and http://community.qlik.com/message/202684#202684

Re: Class function

vikasmahajan — Thu, 18 Jul 2013 05:12:44 GMT

Thanks

Is there anyone have qvw I read all this posts but confused abt class

Vikas

Re: Class function

Thu, 18 Jul 2013 05:31:26 GMT

try this

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 function

vikasmahajan — Thu, 18 Jul 2013 07:18:47 GMT

can u explan me why var=23 return 20<=x<30

Re: Class function

tresB — Thu, 18 Jul 2013 07:27:10 GMT

While you write : class(23, 10), the classification starts from 0. so the points of intervals become like 0, 10, 20, 30 ... Now your variable (23) comes under the interval 20-30. hence the result.

20<=x<30 ... means your variable(23) belongs to this interval.

hope this helps.

Re: Class function

Thu, 18 Jul 2013 09:00:17 GMT

class( var,10 )

here 10 is interval.

if var =23 , then if your data of field start from 10 then after interval of 10 , 23 lie between 20 to 30.

so
var=23 return 20<=x<30

Re: Class function

vikasmahajan — Thu, 18 Jul 2013 09:02:41 GMT

Thanks Sir

Re: Class function

Anonymous — Fri, 10 Apr 2015 03:33:56 GMT

Your explanation is very nice and can you please explain me about Offset in the Syntax

Re: Class function

tresB — Fri, 10 Apr 2015 04:58:31 GMT

Offset is the number the interval starts from.

For, Class(23, 10, 'tres') the default offset is zero, hence the interval becomes like: 0-10, 10-20, 20-30... and the number 23 comes under 20-30 interval. Hence shows the result as 20<=tres<30.

For, Class(23, 10, 'tres', 5) , the interval starts from 5(offset) to generate the intervals like: 5-15, 15-25, 25-35....and the number 23 comes under 15-25 interval. Hence shows the result as 15<=tres<25.

Hope this helps.

Re: Class function

vikasmahajan — Fri, 10 Apr 2015 05:17:08 GMT

Hii,

Tresesco,

Have you implement Predictive analysis can u give guide lines how to implement the same in Qlikview ?

Thanks

Vikas

Re: Class function

Anonymous — Fri, 10 Apr 2015 05:47:56 GMT

Thank you Tresesco