Replicating countif in Qlikview

[#1]

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]

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

Hope it helps.

Marc.

[robert_mika]

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