Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
COUNT1 and COUNT2 are fields or are they expressions?
Hi @sunny_talwar ,they are fileds