Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
count(Distinct {<Customers={"=Sum(customer_gross_sales)>500"}>}Customers)
try this
count(Distinct {<Customers={"=Sum(customer_gross_sales)>500"}>}Customers)
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!
Hi Peter, use Aggr function inside the SET analysis to compare the value.
AGGR(SUM(SALE_AMT),CUSTOMER,PRODUCT)