Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.