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

Help

H

3 Replies
hic
Former Employee
Former Employee

You need to nest it in an if() function:

     If("Inc Rate" >1, '>1', class("Inc Rate",0.1))

HIC

swuehl
MVP
MVP

I believe you need to combine the class() function with an if() statement then:

=if( FIELD <= 1, class(FIELD,0.1), dual('>1.0',1) )

MarcoWedel

maybe this thread helps also?

Custom Filter(unusual range)

regards

Marco