Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Author

try this

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

View solution in original post

3 Replies
Not applicable
Author

try this

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

Anonymous
Not applicable
Author

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
Author

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

AGGR(SUM(SALE_AMT),CUSTOMER,PRODUCT)