# Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
New Contributor

## Class function on decimal numbers

Hi all,

I'm trying to use the Class function to segment out a field that is a decimal value.  If the decimal is <= .85 show 85, if decimal >= 120 show 120.

For some reason I'm running into a problem where QlikSense doesn't seem to be recognizing some of the values in the set, particularly the data from .85 to .9 as a calculated dimension.  If I apply the same formula as a measure, it seems to segment the data correctly.

Set up script:

```[Test]:
LOAD *
INLINE [
Test
209.843
22.329
23.135
23.610
24.680
27.037
28.037
28.070
30.313
32.858
34.696
35.707
36.911
38.336
38.631
38.676
44.062
46.314
47.641
47.940
47.970
53.908
54.151
58.659
59.265
59.775
65.924
66.391
66.720
67.125
67.145
67.296
72.839
73.684
74.866
74.903
75.306
75.558
78.329
79.410
79.817
79.851
80.381
82.186
82.637
84.147
87.913
88.744
90.083
90.212
90.945
91.825
92.244
92.984
93.047
93.089
93.158
94.045
94.984
95.111
95.693
95.809
95.814
95.903
96.230
96.414
96.613
96.734
96.785
98.563
99.037
100.017
100.230
100.301
100.590
100.861
100.955
101.172
]```

Function:

`=IF(Test <= 85, '85', IF(Test >= 120, '120+', Class(Test, 5)))`

Result: I feel like I'm missing something stupid.  On the left is the function as a calculated dimension.  On the right is the function as a measure.  The right side properly displays 85 <= x < 90 but the left is coding as 85.

Thoughts?

Thanks,

Edwin

Tags (2)