Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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] )