Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

Qlik Sence Set Analysis

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

{<any_field={'*'}>}

 

Labels (1)
5 Replies
Taoufiq_Zarra

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") 😉
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

 

It should return ALL values in any_field

Vittore8
Creator
Creator
Author

with null field or without?

Taoufiq_Zarra

@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") 😉
sunny_talwar

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