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

[dberkesacn]

Hi,

The"+"-sign is used for OR in set analysis

Daniel

[tresesco · Accepted solution]

This?

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

[soniasweety]

I have no value as empty   its blank like empty space.can I use this?

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

[antoniotiman]

Hi,

try this

Count({<belongs={"=Len(Trim(belongs))=0"}>} Number)

Regards,

Antonio

[dberkesacn]

with this yes

NullAsValue ‒ QlikView

[tresesco]

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.

[arvind_patil]

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

[soniasweety]

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
];

[soniasweety]

Am unable to mark Helpful   the replies ?