topic Expression values conditioned in QlikView

Expression values conditioned

Mon, 11 Apr 2011 14:51:08 GMT

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 — Tue, 12 Apr 2011 21:53:24 GMT

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,

Wed, 13 Apr 2011 08:09:24 GMT

Ok, thank.

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