# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Contributor

## Re: Help with Invoice equal to zero

The result is ok. Thanks @sunny_talwar

Only a couple of final things to solve based on the previous expression:

1. How can I exclude cases with a charge with zero value? I explain it better, suppose the charges:
'Promotional three months free' and 'Promotional free 3 months' are equal to zero, I would like to exclude those cases.

Although the amount is repeated and the charges are different, when they are equal to zero they have no risk

2. How can I count the cases in a KPI using a text box?

Highlighted
MVP

## Re: Help with Invoice equal to zero

I think my expression is already excluding when the amount  = 0... I reloaded with the new file attached

.

For a distinct count of Invoice Number, you can try this

``=Count(DISTINCT {<[Invoice-Num] = {"=Count(DISTINCT [Charge Details]) > 1 and Max(Aggr(Count({<Taxed_Charge = {[<>0]}>}Taxed_Charge), [Invoice-Num], Taxed_Charge)) > 1 "}>} [Invoice-Num])``

For overall count

``=Count({<[Invoice-Num] = {"=Count(DISTINCT [Charge Details]) > 1 and Max(Aggr(Count({<Taxed_Charge = {[<>0]}>}Taxed_Charge), [Invoice-Num], Taxed_Charge)) > 1 "}>} [Invoice-Num])``

Contributor

## Re: Help with Invoice equal to zero

It works very good!!

thanks for all @sunny_talwar