topic Re: How to move Set Analysis expression to backend script in App Development

How to move Set Analysis expression to backend script

vikasshana — Thu, 06 Mar 2025 18:37:25 GMT

Hi,

I've below set expression.

count(Distinct{<Scope={'1'},Date-={'""'}>}ID).

I would like to move this set expression to backend script. How to achieve it?

Regards,

ramchalla — Fri, 07 Mar 2025 08:53:01 GMT

Hi,

Please try this.

load count(distinct ID),
resident table_name
where Scope=1 and is not null(Date)
;

vikasshana — Fri, 07 Mar 2025 11:28:39 GMT

thanks for that, is it possible to achieve with if condition some thing like below?

count(distinct if(Scope='1' AND Date<>'""',ID))

ramchalla — Fri, 07 Mar 2025 11:41:27 GMT

Hi,

Yes..it will work too.