Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Count

Trying to Count the number of Yes's in a Field [Dynamic 2017 (Y/N)]... keep getting error message.

Count({$<[Dynamic 2017 (Y/N)]={'Y'}>})

2 Replies
oknotsen
Honored Contributor III

Re: Count

And what is the error message that you are getting?

What I notice is that your expression is missing the actual field to count. It seems to only contain the Set Analysis section.

Try this:

Count({$<[Dynamic 2017 (Y/N)]={'Y'}>} [Dynamic 2017 (Y/N)])

May you live in interesting times!
khan_imran
Contributor

Re: Count

try this one -

=Count({$<[Dynamic 2017 (Y/N)]={'Y'}>} Distinct [Dynamic 2017 (Y/N)])


this will give you unique count. First try it in the text object for testing then place it anywhere

Community Browser