Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kathy_parker
New Contributor

How do I write expression to exclude a value?

Field name is Existing Groups.  Values are Yes or No.  How do I write an expression to pull in a count of ONLY the "YES" values?

I would like to create a bar chart that lists a column for "yes" and a column for "no".

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: How do I write expression to exclude a value?

Count({<[Existing Groups]={'YES'}>} [Existing Groups])

3 Replies
antoniotiman
Honored Contributor III

Re: How do I write expression to exclude a value?

Count({<[Existing Groups]={'YES'}>} [Existing Groups])

Khan_Mohammed
Honored Contributor II

Re: How do I write expression to exclude a value?

count(if([Existing Groups]='YES',[Existing Groups], if([Existing Groups]='NO',[Existing Groups] )) )

kathy_parker
New Contributor

Re: How do I write expression to exclude a value?

Thanks!

Community Browser