Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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] )