Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qlik Sence Set Analysis

hi, tell me please, what will this code return?

{<any_field={'*'}>}

 

Labels (1)
5 Replies
Highlighted
Master
Master

All any_field

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Highlighted
Partner
Partner

Hi,

 

It should return ALL values in any_field

Highlighted
Creator
Creator

with null field or without?

Highlighted
Master
Master

@Vittore8 

One exemple :

All value :

count({<any_field={'*'}>} Code)

Not white value :

count({<any_field={"=len(any_field)>0"}>} Code)

white value:

count({<any_field={'*'}-{"=len(any_field)>0"}>} Code)

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Highlighted

True nulls in any_field will not be included when this is used -> {<any_field = {"*"}>}, but white spaces will be included.