Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Nice example thanks
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)
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?
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()
great doc, i suggest check the picture.
thanks for the info, if I want to show the numbers how can I achieve this?
attachment missed I think sir ..
indeed: here you are How to use - Only()
the blog has a nice simple picture plus usefull desc..