NotEquals (PQL)

Checks if two items do NOT match.

  • Returned Output: Boolean
  • Library: PQL \ Common \ Logical
  • Version: 2020.12.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.

Syntax

NotEquals( <Variant> , <Variant> )

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

Comments
  • The 2 variant values supplied must be of the same data type (text vs text, number vs number etc).
  • The method returns true if the result is negative. Otherwise it returns false.
Different Function types

Examples

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

NotEquals(ToLower("APple"), "apple")

This example returns true because 9 doesn't equal 10

NotEquals(4+5, 10)