Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Class function cut off age

Hello, 

I have created age buckets using - =Replace(Class(Age,5),'<= x <', '-')

The chart is displaying buckets up to 2005-2010

How can I make 130-1354 the greatest bucket? 

Thank you

Labels (4)
1 Reply
Vegar
MVP
MVP

Try something like this.

=if(Class(Age,5)>1354,

Class(Age,5),'<= x <', '-'),

dual('130-1354',130))