Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
educastri83
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. 

example 4.png

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

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

Capture.PNG.

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])

 

educastri83
Contributor

Re: Help with Invoice equal to zero

It works very good!!

thanks for all @sunny_talwar