topic Re: "Not equal to" syntax in QlikView

"Not equal to" syntax

Anonymous — Tue, 03 Jul 2012 03:41:05 GMT

Hi, sorry I am a complete newbie and I am sure this is a really simple question.

In my data set I would like to identify all the accounts that are not "active".

I can count all the active accounts by looking at those accounts which have active contacts using the following syntax:

count ( {<[Contact Status]={'Active'}>} distinct ACCOUNTID)

This works great!!

However if I try to do the opposite (contact activity status can be null, inactive, dormant or prospect) using the following syntax:

count ( {<[Contact Status]<>{'Active'}>} distinct ACCOUNTID)

I am told that there is an error (wiggly line under the <> and nothing is returned.

I am sure this is blindingly obvious but I have spent an hour or so on it now and I am about to start sticking needles in my eyes to cheer myself up

Thanks for any help.

Re: "Not equal to" syntax

Tue, 03 Jul 2012 03:53:52 GMT

Try this

count ({<[Contact Status]-={'Active'}>} distinct ACCOUNTID)

Regards,

Kiran Rokkam.

Re: "Not equal to" syntax

Anonymous — Tue, 03 Jul 2012 04:04:27 GMT

This picks up all the things that have a contact status tag that is not "active" - dormant etc, but does not count the null values. Is there a way of counting them also??

Re: "Not equal to" syntax

Tue, 03 Jul 2012 04:08:29 GMT

Please try this

count ( {$-1<[Contact Status]={'Active'}>} distinct ACCOUNTID)

Regards,

Kiran Rokkam.

Re: "Not equal to" syntax

Anonymous — Tue, 03 Jul 2012 04:13:01 GMT

Thanks Kiran, you are a lifesaver!!