Using the class function

[qingkong]

Can I use class grouping to achieve the same effect as shown in the figure

[Or · Accepted solution]

Probably not, since your intervals aren't consistent. However, you can use the same if() logic used in Excel in your Qlik formula.

[qingkong]

Is it ok if the interval value is a reference value