Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
iralza01
Contributor II
Contributor II

Count value where date 1= date 2

Hi, I have the field product ID and I want to count if date 1 = date 2.

Product ID   Date 1           Date 2

22568          21/02/2017     21/02/2017

26987          22/02/2017     23/02/2017

69854          23/02/2017     23/02/2017

Thank you

1 Reply
tresesco
MVP
MVP

It depends on your data model. If all fields are in a single table, try like:

Count( Distinct {<[Product ID]={"=Date1=Date2"}>}[Product ID] )