Counting values based on logical functions (e.g., IsNum())

[prayner]

Using the following set analysis code, I am trying to count the number of distinct locations where the field 'value' does not have numeric values:

Count(${<[IsNum(value)] = {'0'}>} distinct location)

Whether I enter '0' or '-1', I get the same output. How can I fix the syntax to get this to work?

Ref:

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/LogicalFun...

[sandeep-singh]

you can try this

Count({<Not IsNum(value)>} DISTINCT location)

[prayner]

Error in expression
Error in set modifier expression

[Kushal_Chawda]

@prayner  try below

Count(${<location = {"=isnum(value)"}>} distinct location)

[Kushal_Chawda]

@prayner  if you have multiple lines for location. then use primary key in set. If you don't have primary key, create it using Rowno() function in the script for that table

Count(${<PrimaryKey = {"=isnum(value)"}>} distinct location)