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
Hi,
The"+"-sign is used for OR in set analysis
Daniel
This?
count({<belongs={'NULL', 'empty'} >}Number)
I have no value as empty its blank like empty space.can I use this?
count({<belongs={'NULL', ' '} >}Number)
Hi,
try this
Count({<belongs={"=Len(Trim(belongs))=0"}>} Number)
Regards,
Antonio
with this yes
If you are sure that it's a space you can try like that. Otherwise, null, blanks, space, nothings are tricky in data. you have to carefully deal with them.
Hi Sony,
I am Agree with Daniel.Use + Sign for Or Condition Like below.
Sum({<Type={"A"}>+<Type={"z"}>}Sales)
so in above expression, it will show Sale where Type equals A or Z.
Thanks,
Arvind Patil
yes your expression is only for null values ,its working,
I have in data NULL also.
sample:
LOAD * Inline [
number,belongs,data
1,aa,123
2,bb,22
3,cc,34
4,NULL,54
5,NULL,121
6, ,127
7,NULL,88
];
Am unable to mark Helpful the replies ?