Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MK_QSL
MVP
MVP

Use below as Calculated Dimension

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