Equals (PQL)

Checks if two items match.

  • Returned Output: Boolean
  • Library: PQL \ Common \ Logical
  • Version: 2018.00.000
  • Compatibility:
    • Can be combined with and other PQL function throughout the application.
    • It CANNOT be used with MDX or VBA functions. But it can be used on MDX-based content in other parts of the application.


Equals( <Variant> , <Variant> )

* Click on the function's arguments above for more details on the input values.

  • The 2 variant values supplied must be of the same data type (text vs text, number vs number etc).
  • The items must be an exact match - this includes case sensitive text items.
  • The method returns true if the result is positive. Otherwise it returns false.
Different Function types


This example returns true because the input string "APple", in lower case matches the second string "apple"

Equals(ToLower("APple"), "apple")

This example returns false because 9 doesn't equal 10

Equals(4+5, 10)