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.

Syntax:  

alt(expr1[ , expr2 , expr3 , ...] , else)

Arguments:  

Argument Description
expr1 The first expression to check for a valid number representation.
expr2 The second expression to check for a valid number representation.
expr3 The third expression to check for a valid number representation.
else Value to return if none of the previous parameters has a valid number representation.

The alt function is often used with number or date interpretation functions. This way, Qlik Sense 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?