compare 2 fields - set analysis

[Margaret]

I have a field named

     DocumentDate

and a field named

     AuditDate2

and I want to count the records in which both dates are the same. I've tried these and both give me zero (when I know that is not the case). What am I doing wrong?

=count({$<DocumentDate ={"=$(AuditDate2)"}>}OmOrdID)

=count({<DocumentDate={"AuditDate2"}>}OmOrdID)

Both fields are populated in the same format in Table View in QlikView and both come from stored procedures that use the same syntax.

Thank you, in advance, for any assistance you can provide!!

[Matsa]

Thank you @sunny_talwar  for the solution.

I need exact thing but I don't want change the calculation based on selection.

I need count(filed1) where COUNT1=COUNT2

I tried this one , but does not work:

Count (distinct{1< FILED1={"=COUNT1=COUNT2"}>} FILED1)

could you please help me on this matter.

Regards,

Matsa

[sunny_talwar]

COUNT1 and COUNT2 are fields or are they expressions?

[Matsa]

Hi @sunny_talwar ,they are fileds