topic Re: Set analysis question in QlikView

Set analysis question

Anonymous — Fri, 09 May 2014 16:50:12 GMT

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.

Re: Set analysis question

Fri, 09 May 2014 16:56:56 GMT

try this

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

Re: Set analysis question

Anonymous — Fri, 09 May 2014 17:01:46 GMT

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!

Re: Set analysis question

Fri, 09 May 2014 17:04:03 GMT

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

AGGR(SUM(SALE_AMT),CUSTOMER,PRODUCT)