Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dominicelfick
New Contributor

"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.

1 Solution

Accepted Solutions
Not applicable

Re: "Not equal to" syntax

Please try this

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

Regards,

Kiran Rokkam.

4 Replies
Not applicable

Re: "Not equal to" syntax

Try this

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

Regards,

Kiran Rokkam.

dominicelfick
New Contributor

Re: "Not equal to" syntax

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??

Not applicable

Re: "Not equal to" syntax

Please try this

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

Regards,

Kiran Rokkam.

dominicelfick
New Contributor

Re: "Not equal to" syntax

Thanks Kiran, you are a lifesaver!!

Community Browser