startsWith - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.


startsWith evaluates if the expression starts with a substring that you specify. If the expression starts with the substring, startsWith returns true, and otherwise it returns false.


startsWith(expression, substring, string-comparison-mode)



The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.


The set of characters to check against the expression. The substring can occur one or more times in the expression.


(Optional) Specifies the string comparison mode to use:

  • CASE_SENSITIVE – String comparisons are case-sensitive.

  • CASE_INSENSITIVE – String comparisons are case-insensitive.

This value defaults to CASE_SENSITIVE when blank.

Return type



Default case sensitive example

The following case sensitive example evaluates if state_nm startsWith New.

startsWith(state_nm, "New")

The following are the given field values.

New York new york

For these field values, the following values are returned.

true false

Case insensitive example

The following case insensitive example evaluates if state_nm startsWith new.

startsWith(state_nm, "new", CASE_INSENSITIVE)

The following are the given field values.

New York new york

For these field values, the following values are returned.

true true

Example with conditional statements

The startsWith function can be used as the conditional statement within the following If functions: avgIf, minIf, distinct_countIf, countIf, maxIf, medianIf, stdevIf, stdevpIf, sumIf, varIf, and varpIf.

The following example sums Sales only if state_nm starts with New.

sumIf(Sales,startsWith(state_nm, "New"))

Does NOT contain example

The conditional NOT operator can be used to evaluate if the expression does not start with the specified substring.

NOT(startsWith(state_nm, "New"))

Example using numeric values

Numeric values can be used in the expression or substring arguments by applying the toString function.

startsWith(state_nm, toString(5) )