topic Re: Not equals to condition check in count expression in QlikView

Not equals to condition check in count expression

Fri, 24 Aug 2012 05:32:42 GMT

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])

nilesh_gangurde — Fri, 24 Aug 2012 05:34:59 GMT

Hi,

Use this

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

Regards,

Nilesh Gangurde

jagan — Fri, 24 Aug 2012 06:27:36 GMT

Hi Vishal,

Use this expression -= excludes the given values in dimension

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

Regards,

Jagan.