Display only one instance of a discount for an invoice

[ccb-it2013]

Hi there,

Need some help with a Qlikview report I wrote.

The report shows how much discount was given on each invoice. The problem I have is if the invoice have more than 2 items, the discount is displayed twice on the report. How do I get the report to only show me the discount once?

I am using the Expression "discount" and using the definition

max(discount)

Any help would be appreciated.

Thanks,

Ed

[sunny_talwar · Accepted solution]

May be this

Max(Aggr(discount, invoice))

[sunny_talwar]

Although what is the issue with using Max(discount)?

[ccb-it2013]

HI there,

Max(discount) is the function I am using to grab the the discount values. As I mentioned, if the invoices have more than one line to them (more than one item), then the report displays the discount on each item line. I just want to see the discount amount once.

Ed

[ccb-it2013]

Thank you Sunny! Your suggestion seems to have resolved my issue

Cheers!

Ed

[sunny_talwar]

Oh great ... Although this might work also

Aggr(discount, invoice)