3 Replies Latest reply: Oct 8, 2013 7:37 AM by Gysbert Wassenaar RSS

    How to calculate the amount sold in the last invoice

    Aleix Rodriguez Vidal

      Hello,

      I've got a detailed list of invoices (see attached Excel) and I want to plot (in a simple table) the amount sold in the last invoice.

      I've been working with it but I've only been able to show the date oh the last invoice delivered but I didn't succeed with the amount.

      In the attached Qlikview file you'll find the following columns:

      Dimensions:

      - Location: is the warehouse where the invoice was delivered

      - Article

      Expressions:

      - Month_9 and Month_10: Is the amount sold during these months

      - Last Date: Is the date of the last invoice

      - Last Invoice: It should calculate the amount of the last invoice

      I hope somebody can help me.

      Thanks in advance.

      Regards,

      Aleix.