topic Re: Function CLASS in QlikView

Function CLASS

Fri, 27 Feb 2015 21:30:22 GMT

Good Afternoon, I created an interval group using the function CLASS, but when I got the detail of certain group I could see that it did not consider a value that It had to match with this one. The value is counting for the previous group.

I am attaching an image of the table of the group, and the detail.

Re: Function CLASS

Anonymous — Fri, 27 Feb 2015 21:38:34 GMT

is that because of rounding? how many decimal values are there in your data? you may want to check for this case - 0.74999 would be rounded off as 0.7500 if you were to show only 4 decimals but it actually is less than 0.75 - just something to consider.

Re: Function CLASS

MK_QSL — Fri, 27 Feb 2015 22:09:00 GMT

Provide sample document or share your apps...

Or provide the dimension and expression you have used.

Re: Function CLASS

Sat, 28 Feb 2015 03:03:19 GMT

My dimension is class(index,0.05) and expression a simple count.

Enviado desde Yahoo Mail en Android

De:"Manish Kachhia" <qcwebmaster@qlikview.com>

Fecha:Vie, Feb 27, PM a 5:39 PM

Asunto:Re: - Function CLASS

Function CLASS

reply from Manish Kachhia in Scripting - View the full discussion

Provide sample document or share your apps...

Or provide the dimension and expression you have used.

Reply to this message by replying to this email, or go to the message on Qlik Community Start a new discussion in Scripting by email or at Qlik Community

Re: Function CLASS

maxgro — Sat, 28 Feb 2015 15:00:45 GMT

I tried in a small example

load

Rand() as index,

1 as exp

AutoGenerate 100;

load 0.7500000 as index, 1 as exp AutoGenerate 1;

load 0.7500001 as index, 1 as exp AutoGenerate 1;

load 0.7499999 as index, 1 as exp AutoGenerate 1;

0,75 is in the correct class

Re: Function CLASS

Anonymous — Mon, 02 Mar 2015 15:25:41 GMT

nice...on the same token, 0.7499999 is not in 0.75 <= x <= 0.8 class which is what i was saying. if he rounds his values to 4 decimals then 0.74999999 would be displayed as 0.7500 but it is actually less than 0.75 and would not be in the same class as 0.75 <= x <= 0.8...typing the following into a textbox for example

=num(0.7499999, '#.###0')<0.75

Re: Function CLASS

Mon, 02 Mar 2015 16:36:08 GMT

I was thinking that it could be for that, but my result is not rounded. It is 0.75 exactly.

I did another exercise using intervalmatch and I got the same result. It same that the range is 0.70 < x <= 0.75.

Here are my interval match table and the result:

Desde	Hasta	Rango
0,3	0,35	0,30 - 0,35
0,3501	0,4	0,35 - 0,40
0,4001	0,45	0,40 - 0,45
0,4501	0,5	0,45 - 0,50
0,5001	0,55	0,50 - 0,55
0,5501	0,6	0,55 - 0,60
0,6001	0,65	0,60 - 0,65
0,6501	0,7	0,65 - 0,70
0,7001	0,75	0,70 - 0,75
0,7501	0,8	0,75 - 0,80
0,8001	0,85	0,80 - 0,85
0,8501	0,9	0,85 - 0,90
0,9001	0,95	0,90 - 0,95
0,9501	1	0,95 - 1

Thanks to all for your help.

Re: Function CLASS

Anonymous — Mon, 02 Mar 2015 16:43:33 GMT

so is the count for the previous class/interval one more than what it should be? may be posting a sample qvw with the issue will help address this.

Re: Function CLASS

Mon, 02 Mar 2015 21:19:28 GMT

I am attaching the qvw and excel interval match