Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Expression values conditioned

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

1 Solution

Accepted Solutions
vgutkovsky
Honored Contributor II

Expression values conditioned

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,

2 Replies
vgutkovsky
Honored Contributor II

Expression values conditioned

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,

Not applicable

Expression values conditioned

Ok, thank.

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

Community Browser