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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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] )