Select Distinct Expressions

[#1]

Hi Dears!

I'm developing a application on QlikView. But I have a problem when I
use a expressions to count the amount of products.

I attached a screenshot that show a little bit my problem (REPORT_ACTUAL.png).

The dimension "Qtde Transações" (last column) makes the expression follows below:

count(distinct V320DOCAUTCLI) - The field V320DOCATUCLI is dimension "Autorização"

But I need to elimite the values doesn't considered in the count. Follows below
a screenshot that I did to examply how to values should be showed (REPORT_EXPECTED.png).

How can I changes the report to show values as well the screenshot REPORT_EXPECTED.png?

Thank you everybody who can help me.

Fernando Vieira
Analyst BI
Sao Paulo - Brazil