3 Replies Latest reply: May 9, 2014 1:04 PM by Srikanth P RSS

    Set analysis question

      I'm new to QlikView so am struggling to get my head around set analysis.

       

      Where I work we have thousands of customers who each spend differing amounts. We want to look at product penetration amongst our customers, but we only care about customers spending more than £500 a month.

       

      How can I do a count of customers spending more than £500 buying each product in any given time period? Customers are identified with their location id. Could I do a Count If e.g. countif({<sum(customer_gross_sales<500}), although I've no idea how to make this work?

       

      Thanks in advance.