Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
krissy_s
Contributor III
Contributor III

Non alphanumeric characters in string

Hello
I would like to count fields with non-alphanumeric characters, using set analyses (not in the load script).

i.e. if contains non-alphanumeric characters.

Does anyone know how to do this please?

 

1 Reply
marcus_sommer
MVP
MVP

It's not quite clear for me if you want to count fields or fieldvalues. Counting fields within the UI without support from any script-measures will be rather difficult to impossible. Measuring to fieldvalues should be possible with set analysis, for example with something like:

count({< YourField = {"=len(purgechar(YourField, '012..abc..XYZ'))>0"}>} YourField)

- Marcus