Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Count where Value in a Field not equal to

Hi i have the following Expression:

Count({$<[YearDate] = {2012}>}[Location])

How can I make the same expression where the YearDate NOT equal to 2012.

I tried

Count({$<[YearDate] <> {2012}>}[Location]) but it is giving me error.

Thanks,

1 Solution

Accepted Solutions
bgerchikov
Partner - Creator III
Partner - Creator III

Alec,

Try -=

Count({$<[YearDate] -= {2012}>}[Location])

View solution in original post

3 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

Alec,

Try -=

Count({$<[YearDate] -= {2012}>}[Location])

alec1982
Specialist II
Specialist II
Author

I am still getting a little red line under it? would that mean it is wrong?

bgerchikov
Partner - Creator III
Partner - Creator III

No, it doesn't. Sometimes QV shows red even though there is no error. Just try it  out.