topic Help on aggr function in QlikView

Help on aggr function

Tue, 03 Jul 2012 12:23:44 GMT

Hi,

How to show the number of countries which don't have any sales on that day.

Data:

Date Country Sales

1-July A 100

1-July B 0

1-July C 200

2-July A 0

2-July B 0

2-July C 100

Output:

Date No sales(No.of.Countries)

1-July 1

2-July 2

cesaraccardi — Tue, 03 Jul 2012 12:36:54 GMT

Hi, you could try:

count({$<Country={"=sum(Sales)=0"}>} Country)

swuehl — Tue, 03 Jul 2012 12:41:03 GMT

Try

=sum( aggr( if(sum(Sales)=0,1,0),Country, Date))