Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

ccb-it2013
New Contributor

Display only one instance of a discount for an invoice

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

1 Solution

Accepted Solutions

Re: Display only one instance of a discount for an invoice

May be this

Max(Aggr(discount, invoice))

5 Replies

Re: Display only one instance of a discount for an invoice

May be this

Max(Aggr(discount, invoice))

Re: Display only one instance of a discount for an invoice

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

ccb-it2013
New Contributor

Re: Display only one instance of a discount for an invoice

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
New Contributor

Re: Display only one instance of a discount for an invoice

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

Cheers!

Ed

Re: Display only one instance of a discount for an invoice

Oh great ... Although this might work also

Aggr(discount, invoice)

Community Browser