topic Re: Replicating countif in Qlikview in QlikView

Replicating countif in Qlikview

Tue, 10 Feb 2015 14:54:54 GMT

I'm trying to replicate a countif I have used in excel as calculated field in a Qlikview table.

The countif is designed to count how many times a customer contacts again within 7 days of that record.

Column A is the customer ID

Column B is the contact date/time

=COUNTIFS(A:A,A2,B:B,">"&B2,B:B,"<" &B2 +7)

Can anybody help replicate this in Qlikview?

Anonymous — Wed, 11 Feb 2015 11:13:02 GMT

Please find attached. You will see a way to do this in script.

Hope it helps.

Marc.

robert_mika — Wed, 11 Feb 2015 11:20:25 GMT

Try

=SUM(IF(MODEL='A' AND VIN>'$(vB)' AND VIN<'$(vB)'+7,1))

where '$(vB)' is a variable

(To create variable

Settings->Variable Overview -->Add