topic Count customers with sales between $1000 and $3000 using Set Analysis in QlikView

Count customers with sales between $1000 and $3000 using Set Analysis

Anonymous — Wed, 30 Jun 2010 12:42:04 GMT

Hi everyone,

There is a need to count distinct customers who have sales in defined range for selected period.

In help I found this example:

sum( {$<Customer = {"=Sum({1<Year = {2007}>} Sales ) > 1000000"}>} Sales )

transforming in to my case it looks like

=count( {$<Customer={"=Sum(Price*Qty) > 1000"}>} distinct Customer)

But how to add the top value of sales, so I'd have count of Customers, who have sales more than 1000 and less than 3000?

Thanx in advance

Rds,
AT

sparur — Wed, 30 Jun 2010 12:54:10 GMT

Hello, Artjoms.

may be like this:

=count( {$<Customer={"=Sum(Price*Qty) > 1000"} * {"=Sum(Price*Qty) < 3000"}>} distinct Customer)

Anonymous — Wed, 30 Jun 2010 13:12:37 GMT

Cool, it worked

I din't knew about using star in set Analysis sintax

Thanx a log

Rds,
AT

sparur — Wed, 30 Jun 2010 13:23:51 GMT

yes, we could. as well as +, - and /

Anonymous — Wed, 30 Jun 2010 13:30:53 GMT

Is there some additional information available about using these symbols in Set Analysis?

sparur — Wed, 30 Jun 2010 13:32:56 GMT

you can download one useful pdf:

http://community.qlik.com/Search/search.aspx?q=QlikLearn-Set-Analysis-Presentation