How to move Set Analysis expression to backend script

[vikasshana]

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,

V

[ramchalla]

Hi,

Please try this.

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

[vikasshana]

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

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

[ramchalla]

Hi,

Yes..it will work too.