Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Payman
Contributor
Contributor

Conditional count on date field

Hi,

We have a date field with this format '2019-04-28 04:45:01.000'. Want to count the IDs where the date is equal to today's date. I used the below one but it is not true:

=Count(If(Date(CreateDate,'YYYY/MM/DD')=Date(Today(),'YYYY/MM/DD'),ID))

Labels (3)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

Try this expression:
Count({<CreateDate={">=$(=daystart(today()))<=$(=dayend(today()))"}>} ID)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
Partner
Partner

Try this expression:
Count({<CreateDate={">=$(=daystart(today()))<=$(=dayend(today()))"}>} ID)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post