Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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
Highlighted
MVP
MVP

This?

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

View solution in original post

17 Replies
Highlighted
Partner
Partner

Hi,


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


Daniel

Highlighted
MVP
MVP

This?

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

View solution in original post

Highlighted
Specialist III
Specialist III

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

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

Highlighted
Master III
Master III

Hi,

try this

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

Regards,

Antonio

Highlighted
Partner
Partner

with this yes

NullAsValue ‒ QlikView

Highlighted
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.

Highlighted
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

Highlighted
Specialist III
Specialist III

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

Highlighted
Specialist III
Specialist III

Am unable to mark Helpful   the replies ?