topic Count Blank fields in an expression in QlikView

Count Blank fields in an expression

sabrina87 — Fri, 12 Feb 2021 21:38:49 GMT

Hi all,

I am trying to count in an expresion when it meets 2 conditions but it is not working, could you help me?

It should count when the field compliant is No and Label is blank

count({<[compliant]={'No'},'LEN(TRIM(LABEL))=0'>} [compliant])

Thanks in advance!

edwin — Fri, 12 Feb 2021 23:04:42 GMT

try

count({<[compliant]={'No'},LABEL={"*"}-{''}>} [compliant])

edwin — Fri, 12 Feb 2021 23:05:22 GMT

{"*"} means NONE NULL values
-{''} means exclude blanks

edwin — Fri, 12 Feb 2021 23:07:22 GMT

i read it the other way, if you are looking for just blanks (NOT NULL - there's a difference)

count({<[compliant]={'No'},LABEL={''}>} [compliant])

edwin — Fri, 12 Feb 2021 23:15:54 GMT

if you are looking for NULL:

{<complaint={'No'}>-<complaint={'No'}, LABEL={"*"}>}

get everything with complaint=No less those with a Label