0 Replies Latest reply: Jul 19, 2017 5:13 PM by Emmanuel Reisman RSS

    How to filter customers that have not ordered in the past 6 months

    Emmanuel Reisman

      Hi,

       

      I am using Quickbooks Advanced Reporting which is powered by QlikView.

       

      I am trying to be able to filter all customers [Customer.Full Name] that have not ordered in the past 6 months.

       

      It will also be helpful if the filter can be set to only include customers that have placed orders in the past 12 months.

       

      I am not sure what would be the best way to set this up. either by having an expression in a List Box. or by setting it up in a chart.

       

      Thank you very much,

      E