5 Replies Latest reply: Mar 16, 2017 9:39 AM by Sunny Talwar RSS

    Display only one instance of a discount for an invoice

    Edward Del Rincon

      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