Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
xtrimf
Creator
Creator

Class limit possible?

Hi,

When using the class function is it possible to limit its high value?

For example if it is used on month like this: class(Month,7)

then the results will be "0<=Month<7" and "7<=Month<14"

14 is not a month....I need it to write "Month>=7"

Any suggestion?

tnx

1 Reply
prieper
Master II
Master II

Hi,

you can add an if-clause to your class-function, like: If(YourValue > 10, '>10', class(YourValue, x))

HTH

Peter