topic Re: about class() function in QlikView

about class() function

Tue, 25 Nov 2014 09:39:16 GMT

here in Class() what is[value] ??? and why we are using 10??

plese give me the answer.....

those data should be coming in between <= and < (or) >= and < like that.

what is the main theme of class() function??

please tell me.....

Re: about class() function

Tue, 25 Nov 2014 12:20:16 GMT

class function is used for classification of expression

class(value,10) syntax returns like this value<=x<10 here 10 is the interval

in your scenario first value is 10

then 10<=x<10

next 11 gives like 1<=x<10 , 11<=x<20 your value between 11 its in between of 11<=x<20

like this all ....

i hope u understood

Re: about class() function

Tue, 25 Nov 2014 13:08:14 GMT

hello,

I have another doubt.not class().

i.e we have 2 txt files .one file date in MM/DD/YYYY format.

another txt file date in YYYY/MM/DD format.

combining these 2 txt files. we will get the date format as DD/MM/YYYY.by using Date# function.

How to get it in DD/MM/YYYY format?? by using "Date#".

please send me answer..............

Re: about class() function

Tue, 25 Nov 2014 13:13:02 GMT

Hi,

Class function will divide the values as you gave here 10

here it will divide like

1>=x<10

11>=x<20

21>=x<30

31>=x<40

41>=x<50

in 1 field only.this is just like a bucket field.

and your second scenario

Date(date#(datefield,'DD/MM/YYYY'),'DD/MM/YYYY') as New_Date

Re: about class() function

Tue, 25 Nov 2014 13:17:34 GMT

try this it works ,

date(date#(yourdatefield,'mm/dd/yyyy'),dd/mm/yyyy)

vishnu priya pls close this thread and raise a new question

endhukante ila raise chesthe we may forget to see ur question.

Re: about class() function

Tue, 25 Nov 2014 13:19:42 GMT

how to close thread??

Re: about class() function

Tue, 25 Nov 2014 13:35:45 GMT

that date function is not working....

please help me for this.....

Re: about class() function

Tue, 25 Nov 2014 13:37:37 GMT

click on ur question (open your inbox>right click on your question>open in new tab > u will get options liek correct and helpful answers

Re: about class() function

Tue, 25 Nov 2014 13:41:09 GMT

try with out comma

date(date#(yourdatefield,'mm/dd/yyyy')dd/mm/yyyy)

if not worked pls post some sample data

Re: about class() function

Tue, 25 Nov 2014 13:49:21 GMT

this date function not working.

please give me another scenario....

Re: about class() function

Tue, 25 Nov 2014 14:01:08 GMT

Hi,

The syntax of Class() is

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

It creates a classifications of expressions. The result will be in the format of a<=x<b where a is lower limit and b is the upper limit.

For Example:

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'

Here interval is 10 and x is 10,11,15,51

for 10 it result will be 10<=x=20

for 11 it result will be 10<=x=20

for 15 it result will be 10<=x=20

for 51 it result will be 50<=x=60

Thanks