topic Qlik Sence Set Analysis in Visualization and Usability

Qlik Sence Set Analysis

Vittore8 — Sat, 16 Nov 2024 18:23:58 GMT

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

{<any_field={'*'}>}

Taoufiq_Zarra — Wed, 08 Jul 2020 08:58:01 GMT

All any_field

Gabriel — Wed, 08 Jul 2020 09:01:09 GMT

Hi,

It should return ALL values in any_field

Vittore8 — Wed, 08 Jul 2020 10:52:01 GMT

with null field or without?

Taoufiq_Zarra — Wed, 08 Jul 2020 11:32:49 GMT

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)

sunny_talwar — Wed, 08 Jul 2020 11:24:57 GMT

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