Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Or in SetAnalysis

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

This?

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

View solution in original post

17 Replies
dberkesacn
Partner
Partner

Hi,


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


Daniel

tresesco
MVP
MVP

This?

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

soniasweety
Master
Master
Author

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

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

antoniotiman
Master III
Master III

Hi,

try this

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

Regards,

Antonio

dberkesacn
Partner
Partner

with this yes

NullAsValue ‒ QlikView

tresesco
MVP
MVP

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
Partner
Partner

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
Master
Master
Author

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
Master
Master
Author

Am unable to mark Helpful   the replies ?