Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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,
Ok, thank.
I have tried successfully with Pick(myMonthField, 'January', 'February', 'March', ...).