topic Re: Conditional count in QlikView

Conditional count

philrumbold — Tue, 25 Sep 2012 09:41:01 GMT

How do I create an expression for a count of the number of records in a table that is conditioned by another row in the the table?

for example, the script below produces the total number of records, whereas I want total number of records created on or after 1st August 2012

RecCount:

Load count(distinct [rec key]) as [record Count]

From

[PR C121881.xls]

(biff, embedded labels, table is Sheet1$)

WHERE([record Created] <= '01/08/2012') ;

alwinsch — Tue, 25 Sep 2012 10:01:00 GMT

Hi,

I used the function below

count ({<[Interne Comm - Binnen uw dienst]={'Voldoende'}>} distinct [MW Naam])

where

[Interne Comm - Binnen uw dienst] has to be your date field

and [MW Naam] is your number field

Regards,