QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

alt - script and chart function

The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.


alt(case1[ , case2 , case3 , ...] , else)


The alt function is often used with number or date interpretation functions. This way, QlikView can test different date formats in a prioritized order. It can also be used to handle NULL values in numerical expressions.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?