Or in SetAnalysis

[soniasweety]

Hi all,

I want to use or in set analysis how can I write the syntax?

I want to write  belongs to = null  or empty         how can I write for empty?

count({<belongs={'NULL'} >}Number)

Thanks

Sony

[soniasweety]

Nice example thanks

[Kushal_Chawda]

better way to do it is to create the flag in script and use that in set analysis

LOAD ...

if(len(trim(belongs))<=0 or lower(trim(belongs))='null' , 1) as EmtyFlag

..

Now use set analysis like below

Count({<EmtyFlag={1}>}Number)

[soniasweety]

thanks kush. instead of count of ,sum of numbers I want to show that numbers along with it .

can I use the Only function instead of  count/sum?  is it make sense?

[dberkesacn]

I think no because only gives you the value if the field has only one and if the field has not only one value returns null()

[dberkesacn]

great doc, i suggest check the picture.

[soniasweety]

thanks for the info,  if I want to show the numbers how can  I achieve this?

[soniasweety]

attachment missed I think sir ..

[dberkesacn]

indeed: here you are How to use - Only()

the blog has a nice simple picture plus usefull desc..