topic Re: Count if not? in QlikView

Count if not?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am new to Qlikview and I'm wondering if I can count if a value is not equal to something. I'm trying to count all instances of something excluding one date, is there anyway I can do this?

Re: Count if not?

agomes1971 — Wed, 06 Jun 2018 12:55:36 GMT

Hi,

please read this:

Excluding values in Set Analysis

HTH

André Gomes

Re: Count if not?

vvvvvvizard — Wed, 06 Jun 2018 13:05:24 GMT

Count({<Field=-{Value to exclude}>}Value)

Re: Count if not?

Chanty4u — Wed, 06 Jun 2018 13:18:28 GMT

or this

Count({<Field-={'Value to exclude'}>}Value)

Count({<Field/={'Value to exclude'}>}Value)