Skip to main content
Question

I want to use Crop Selection as filter for only one sheet in studio not all sheets. How can I do? I think I need to load script for that sheet. I need to basic pql for crop selection.

  • October 6, 2021
  • 2 replies
  • 24 views
O
Level 1

I need a pql of first occurrence of ACTIVITY 1 to last occurrence of ACTIVITY 2. same as crop selection part. Thanks.

2 replies

R
Level 8
Forum|alt.badge.img+12

Hi @ozgur.gunes11 

 

I believe crop selection can be done using sheet filter.

 

You can use below PQL in load script.

 

FILTER ACTIVITY_LEAD ("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" ) = 'Name of activity1' AND ACTIVITY_LAG ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" ) = 'Name of activity2' ;

 

Hope it helps.

A
Level 0
Hi @ozgur.gunes11, thank you for reaching out. Please be informed that this can achieved by using the following formula: FILTER ISNULL(CALC_CROP_TO_NULL(FIRST_OCCURRENCE['Activity 1'] TO LAST_OCCURRENCE['Activity 2'], "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN")) = 0 as a load script on the sheet. You would just need to replace the activities and activity table with your own. Many thanks for your patience and understanding.
Community Code of ConductAccessibility statement