Expression values conditioned

[#1]

Hi,

in a my chart I want to implement an expression with values conditioned by a multiple IF.

But for an expression does it exist a statement like CASE to assign a value depends on a certain numeric value?

Fe, if I have 1, 2, 3, ... I want to value my expr as January, February, March ...

Thanks

[vgutkovsky · Accepted solution]

Yes, the QlikView equivalent is pick(match()). So for example, if the field you are checking is called Field1, you can say:

pick(match(Field1,1,2,3),
Expression1,
Expression2,
Expression3
)

Regards,

[#3]

Ok, thank.

I have tried successfully with Pick(myMonthField, 'January', 'February', 'March', ...).