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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not equals to condition check in count expression

I AM CREATING A CHART AND AM GOIVING THIS IN EXPRESSION

I want to get the count of tac where base station name !='Lloyd' How to do so

I gave the below and it is not working

=Count({<[Basestation Name] = {"<>Lloyd"}>} [Tac Number])

1 Solution

Accepted Solutions
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi,

Use this

=Count({<[Basestation Name] -= {"Lloyd"}>} [Tac Number])

Regards,

Nilesh Gangurde

View solution in original post

2 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi,

Use this

=Count({<[Basestation Name] -= {"Lloyd"}>} [Tac Number])

Regards,

Nilesh Gangurde

jagan
Partner - Champion III
Partner - Champion III

Hi Vishal,

Use this expression -= excludes the given values in dimension

=Count({<[Basestation Name] -= {"Lloyd"}>} [Tac Number])

Regards,

Jagan.