Hello All, I am trying to get a KPI PQL statement for SAP field KDATE(Date) when the date in the field = 9999-12-31
Has anyone done PQl statements like this before? Thanks for your help in inadvance
Page 1 / 1
Hello, yes, you can achieve that in Celonis.
I am not fully sure what information exactly you want to achieve but probably one of this 2 possibilities will solve the issue:
Imagine you want to get the number of cases where KDATE = 9999-12-31
-> using CASE WHEN: Here, the case when will work exactly like in SQL and iterate only by those cases that comply with the condition KDATE = 9999-12-31 SUM(case when "EKPO"."KDATE" = '9999-12-31' then 1 else 0 end)
-> using a Component Filter: Here you can create a KPI that displays the number of cases (PQL: COUNT_TABLE("EKPO")) and then add a filter on top so that only those with EKPO.KDATE = 9999-12-31 appear (PQL: FILTER "EKPO"."KDATE" = '9999-12-31')
Thank You
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.