topic Count if two dates match. in QlikView

Count if two dates match.

Tue, 17 Sep 2013 23:43:49 GMT

Hi -

I am trying to count the number of (sales) deals in a given month for sales agents that were boarded in that month only. I am using the MonthEnd function on both the sales agent boarding time stamp and the deal time stamp, then I am trying to say if the two dates are equal, count the deal.

Can someone send me a script to do this?

I tried

count({<[MonthEnd(Deal.ApprovalDate)] = ([MonthEnd(SalesAgent.DateCreated)])>}Deal.ID)

but this ends up counting the number of deals in two adjacent months, i.e, June & July when I only want June.

Thanks,

Mike

Re: Count if two dates match.

CELAMBARASAN — Wed, 18 Sep 2013 00:25:01 GMT

Should be like this

count({<Deal.ID = {"=Floor(MonthEnd(Deal.ApprovalDate))=Floor(MonthEnd(SalesAgent.DateCreated))"}>}Deal.ID)

Re: Count if two dates match.

Mon, 23 Sep 2013 16:19:18 GMT

This returns no deals, 0. Any other suggestions?