Value between

[Shalini_M]

Case

When value BETWEEN 0 AND 2000 'a)ClassA'

When value BETWEEN 2000 AND 4000 'b)ClassB'

ELSE as CLASSZ

[BrunPierre · Accepted solution]

I suppose you want to create the following Case statement in Qlik? Then this

IF(Value >=0 and value <=2000 ,'ClassA',

IF(Value >=2000 and value <=4000 ,'ClassB','CLASSZ'))

[MarcoWedel]

What is your question?