Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
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,

View solution in original post

2 Replies
Highlighted
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,

View solution in original post

Highlighted
Not applicable

Expression values conditioned

Ok, thank.

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