Skip to main content
Question

How to Exclude NULL Values in a CASE WHEN Statement in PQL?

  • December 11, 2024
  • 0 replies
  • 56 views

leon.boere
Level 1

Hi All,

When using a case when statement how would I go about excluding all the values which are not true from the result.

Lets say:
CASE WHEN PROCESS EQUELS 'A' -> 'B'
THEN 'A to B'
WHEN PROCESS EQUELS 'C' -> 'D'
THEN 'C to D'

Now I'm only interested in plotting the values fall in the 'buckets' basically. How do I exclude the rest which are NULL (very large number of cases).

0 replies

Be the first to reply!