topic distinct with set analysis question in QlikView

distinct with set analysis question

gerrycastellino — Wed, 25 Nov 2020 16:16:04 GMT

Trying to add a simple set analysis to this distinct expression:

Count( DISTINCT [account_uuid ])

would like it to count distinct only when sfdc_account_id is NOT NULL.

I've tried changing this to;

Count( DISTINCT {< sfdc_account_id > {''} >} [account_uuid ])

something's missing, it won't take it:

sunny_talwar — Wed, 20 Apr 2016 21:52:19 GMT

Try this:

Count(DISTINCT {<sfdc_account_id = {'*'}>} [account_uuid ])

sfatoux72 — Wed, 20 Apr 2016 21:56:18 GMT

T‌ry this :

count({<sfdc_account_id={"*"}>} DISTINCT account_uuid)

sunny_talwar — Wed, 20 Apr 2016 21:57:57 GMT

Why the = sign Sébastien Fatoux‌? I have never seen this, so just curious

sfatoux72 — Wed, 20 Apr 2016 22:24:09 GMT

‌it was an error that I corrected just after sending

But in your expression, you use simple quote. I thing it's better to use double quote to use search syntax.

sunny_talwar — Wed, 20 Apr 2016 22:27:01 GMT

But this is a single string, would it really matter?