Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

peter_thornton
New Contributor III

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.

1 Solution

Accepted Solutions
Not applicable

Re: Set analysis question

try this

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

3 Replies
Not applicable

Re: Set analysis question

try this

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

peter_thornton
New Contributor III

Re: Set analysis question

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!

Not applicable

Re: Set analysis question

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

AGGR(SUM(SALE_AMT),CUSTOMER,PRODUCT)

Community Browser