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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count if not?

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?

3 Replies
agomes1971
Specialist II
Specialist II

Hi,

please read this:

Excluding values in Set Analysis

HTH

André Gomes

vvvvvvizard
Partner - Specialist
Partner - Specialist

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

Chanty4u
MVP
MVP

or this

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


or


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