Discussion board where members can get started with QlikView.
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 ...
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)
View solution in original post
I have tried successfully with Pick(myMonthField, 'January', 'February', 'March', ...).