Set analysis question

[Anonymous]

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.

[#2 · Accepted solution]

try this

count(Distinct {<Customers={"=Sum(customer_gross_sales)>500"}>}Customers)

[Anonymous]

I'm pretty sure that has worked (I say pretty sure because I should probably validate the data it has given). If this is correct it's a big help for me so thanks very much!

[#4]

Hi Peter, use Aggr function inside the SET analysis to compare the value.

AGGR(SUM(SALE_AMT),CUSTOMER,PRODUCT)