topic Count all something when a value is not ... in QlikView

Count all something when a value is not ...

Wed, 22 Sep 2010 12:51:23 GMT

Hi,

We normally use Count({$<Field={'Value'}>}something)

How about count all something when the Field is NOT 'Value'.

Is there any all-in-one expression instead of reaching the result through straightforward multiple calculations.

Thanks.

surender_mehta — Wed, 22 Sep 2010 13:05:01 GMT

Hi,

You can first count all the values and then subtract from all to the selective values

e.g.

=count({<,Field={"*"}-{"Value"}>}TxnID).

Try this , hope will work

regards

Surender Mehta

Wed, 22 Sep 2010 13:18:52 GMT

Works fine.

Thanks.