How to check whether a certain activity has occurred more than once , twice for a single case using PQL??

How to check whether a certain activity has occurred more than once , twice for a single case using PQL
??

Page 1 / 1

Hi,

You can try use CASE WHEN statement for this one.

Something like:

SUM(CASE WHEN "ACTIVITES"."ACTIVITY" = 'Name_of_activity' THEN 1 ELSE 0 END)

Regards,

Marcin

Hi @Dipro Banerjee ,

Use

PU_COUNT ( "CASE_TABLE", "ACTIVITIES"."ACTIVITY", "ACTIVITIES"."ACTIVITY" IN ('Activity you're interested in') )

Thanks for both the solutions.

Sign up