Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please find attached. You will see a way to do this in script.
Hope it helps.
Marc.
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