topic Re: Set Analysis: syntaxes, functions. in QlikView

Set Analysis: syntaxes, functions.

giovannarugerio — Sat, 16 Nov 2024 05:00:24 GMT

I'm trying to count how many emails with a number in the username are, and display it in a KPI.

I tried with this

count({1<email ={"$(= purgechar(email,'0123456789')"}>)}email)

but it's not working.

m_woolf — Mon, 10 Dec 2018 19:01:47 GMT

You might want to create a flag in script to make this easier.

if(email = purgechar(email,'0123456789'),1,0) as EmailNum,

Then the expression becomes:

count({1<EmailNum = {1}>)}email)

sunny_talwar — Mon, 10 Dec 2018 19:12:00 GMT

or may be this

Count({1<email = {"=Len(KeepChar(Only({1} email), '0123456789')) > 0"}>} email)