Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
beginner91
New Contributor III

dont count some values

hello all,

is there a formular which exclude some value in a table? 

like Count({<number5={'a', 'b', 'c'....

or maybe put it in the dimension???

Tags (3)
Labels (3)
1 Solution

Accepted Solutions

Re: dont count some values

For excluding you can do this

Count({<number5 -= {'A', 'B', 'C'}>} Something)

or this

Count({<number5 = e({<number5 = {'A', 'B', 'C'}>})>} Something)
1 Reply

Re: dont count some values

For excluding you can do this

Count({<number5 -= {'A', 'B', 'C'}>} Something)

or this

Count({<number5 = e({<number5 = {'A', 'B', 'C'}>})>} Something)