topic Re: Total Exceptions in QlikView

Total Exceptions

Cadbury — Wed, 25 Nov 2020 16:16:04 GMT

I have 2 columns, Vendor and Tax Code. Ideally, a vendor would only use one code. However, exceptions may occur. I need to display the total number of exceptions. So if I have 10 vendors and 3 of them use more than one tax code, I need to display 3 as my answer. The difficulty is that the data is structured like this:

Vendor Code Amount

ABC X1 100

ABC X2 150

DEF X1 120

DEF X2 130

GHI X1 115

ABC X3 130

In this example, Vendor ABC uses 3 tax codes, and Vendor DEF uses 2 codes. So the result should be 2 exceptions.

Any ideas?

Re: Total Exceptions

jaibau1993 — Thu, 14 Nov 2019 12:33:09 GMT

Hi!

Try something like

Count(Distinct {<Vendor = {"=Count(Distinct Code) > 1"}>} Vendor)

Let me know any doubts about the expression.

Regards,

Jaime.

Re: Total Exceptions

sunny_talwar — Thu, 14 Nov 2019 12:34:16 GMT

Try this

Count(DISTINCT {<Vendor = {"=Count(DISTINCT Code) > 1"}>} Vendor)

Re: Total Exceptions

Cadbury — Thu, 14 Nov 2019 13:13:01 GMT

Perfect. Thank you both so much for your help! 🙂