Calculator
The calculator can calcalutate a new value from one or more inputs with the following operators:
[Boolean] NOT- Converts a Boolean to the opposite value. (-1,trueandTrueare all truthy values)[Boolean] AND- Combines two Booleans into one by using a boolean AND. (both values must be truthy for an output oftrue)[Boolean] OR- Combines two Booleans into one by using a boolean OR. (at least one value must be truthy for an output oftrue)[Boolean] XOR- Combines two Booleans into one by using a boolean XOR. (exactly one value must be truthy for an output oftrue)[Number] Equality- Checks if two numbers are equal.[Number] Less Than- Checks if the first number is less than the second.[Number] Greater than- Checks if the first number is greater than the second.[Number] Less than or Equal- Checks if the first number is less than or equal to the second.[Number] Greater than or Equal- Checks if the first number is greater than or equal to the second.[Number] Plus- Adds two numbers.[Number] Minus- Subtracts two numbers.[Number] Times- Multiplies two numbers.[Number] Divide By- Divides the first by the second numbers.[Number] Power- Raises the first number to the power of the second.[Number] Modulo- Returns the remainder of the first number divided by the second.[Number] Whole Integer Division- Returns the first number divided by the second rounded down to the nearest whole number.[Number] Maximum- Returns the maximum of two numbers.[Number] Minimum- Returns the minimum of two numbers.[Number] Round- Rounds a number to the nearest integer.[Number] Floor- Rounds a number down to the nearest integer.[Number] Ceil- Rounds a number up to the nearest integer.[Number] Sign- Returns the sign of a number.[Number] Random Integer between- Returns a random integer between the first and second number.[Text] Contains- Checks if the first string contains the second string.[Text] Matches- Checks if the first string matches the second string.[Text] Concatenate- Concatenates two strings.[Text] Split- Splits a string into an array of strings.[Text] Trim- Removes leading and trailing whitespace from a string.[Text] Repeat n times- Repeats a string n(second input) times.[Text] Fill with Leading Zeros- Fills a string with leading zeros to a given length.[Text] Length Value- Returns the length of a string.[Text] Length Greater than- Checks if the length of a string is greater than the second number.[Text] Length Equals- Checks if the length of a string is equal to the second number.[Text] Length Smaller than- Checks if the length of a string is smaller than the second number.[Array] Length Equals- Checks if the length of an array is equal to the second number.[Array] Length Is Less Than- Checks if the length of an array is less than the second number.[Array] length is Greater than- Checks if the length of an array is greater than the second number.[Array] Length- Returns the length of an array.QlikExprWithReplacement- Define Variable values for replacement in the Variables Tab. These Replacement are of the form:$(varname). This variables may be used in theQlik Expressionto get a value from the Qlik datamodel.Custom- This is a custom math expression. You can define arugments in a list above and use them in your expression. The expression can include all arguments and supports almost all math operators. The advantage is you can combine complex Math calculations into one Step.