topic Re: Count records filtered by two fields in QlikView

Count records filtered by two fields

william_denholm — Tue, 04 Aug 2015 10:51:44 GMT

Hello,

Trying to do a count of records where the type is 'Order' and the status is 'Accepted'

Data in the format below

So I'm expecting the count of Accepted ORD to be 2.

I've tried to COUNT(IF(Order = 'ORD' AND Status = 'Accepted', Order)) but this doesnt seem to work.

Thanks.

Gysbert_Wassenaar — Tue, 04 Aug 2015 10:53:30 GMT

Try count({<Order={'ORD'},Status={'Accepted'}>}Number)

But the expression you posted works fine with the data you posted too. Make sure to use the exact case sensitive file names.

sunny_talwar — Tue, 04 Aug 2015 10:54:50 GMT

Try this:

=Count({<Order = {'ORD'}, Status = {'Accepted'}>}Order)

william_denholm — Tue, 04 Aug 2015 10:57:45 GMT

Thank you!