Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Class Upper Limit

Hello Guys

please look at this :

class (distance, 0.5, x)

Distanse is the expression .

0.5 is interval.

x is string.

How can I limit the distance so the classification  will be until 3?

what's the syntax of class should be in that case?

now  it gives me this:

0-0.5

0.5-1

1-1.5

1.5-2

2-2.5

2.5-3

3-3.5

3.5-4

4-4.5

4.5-5

etc....

1 Reply

Re: Class Upper Limit

Use below as Calculated Dimension

=IF(Aggr(SUM(Distance),FieldName)<=3,Class(Aggr(SUM(Distance),FieldName),0.5),'3+')

Community Browser