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

[Anonymous]

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 · Accepted solution]

Hello, Artjoms.

may be like this:

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

[Anonymous]

Cool, it worked

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

Thanx a log

Rds,
AT

[sparur]

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

[Anonymous]

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

[sparur]

you can download one useful pdf:

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