topic Re: Count where field contains Y in QlikView

Count where field contains Y

danielnevitt — Tue, 29 Dec 2020 14:57:34 GMT

Hi,

I have a field named CompanyGEnUK that contains either Y or N. I am struggling to create an expression that:

1) counts when CompanyGEnUK = Y

2) only shows the results where CompanyGEnUK includes Y

In point 2, the data may have 10 result of which 5 contain CompanyGEnUK = Y. I would like to show these results and exclude any where all the CompanyGEnUK = N

Thanks for your help.

Regards,
Daniel

Re: Count where field contains Y

Anil_Babu_Samineni — Tue, 29 Dec 2020 14:59:36 GMT

You mean like this

Count({<CompanyGEnUK = {'Y'}>} CompanyGEnUK)

Re: Count where field contains Y

danielnevitt — Tue, 29 Dec 2020 15:02:04 GMT

Thank you for the quick reply.

Is there a way to only show records where the count is greater than 0?

Regards,
Daniel

Re: Count where field contains Y

Anil_Babu_Samineni — Tue, 29 Dec 2020 15:05:02 GMT

Perhaps this

Count({<CompanyGEnUK = {'Y', "=Count({<CompanyGEnUK = {'Y'}>} CompanyGEnUK)>0"}>} CompanyGEnUK)

Re: Count where field contains Y

danielnevitt — Tue, 29 Dec 2020 15:12:02 GMT

Thanks that works to show the count. However as I have multiple other expressions, it shows all of the results including where the above field equals 0.

Regards,
Daniel

Re: Count where field contains Y

Anil_Babu_Samineni — Tue, 29 Dec 2020 15:21:22 GMT

Don't include red part in other expressions IF u don't need