
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"Not equal to" syntax
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.
- Tags:
- new_to_qlikview
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please try this
count ( {$-1<[Contact Status]={'Active'}>} distinct ACCOUNTID)
Regards,
Kiran Rokkam.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
count ({<[Contact Status]-={'Active'}>} distinct ACCOUNTID)
Regards,
Kiran Rokkam.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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??

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please try this
count ( {$-1<[Contact Status]={'Active'}>} distinct ACCOUNTID)
Regards,
Kiran Rokkam.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Kiran, you are a lifesaver!!
