Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
LauraMorris
Contributor III
Contributor III

Set analysis - column contains dates before today.

I am trying to get a count of surveys where the eventdate is before today.

eventdate is in the format DD/MM/YYYY if that makes a difference, this is the same format set as the date format at the start of the load script. It returns  a count of - 

count({<[visitreason2]={"*Survey*"} [eventdate] = {"<=$(=Today())"}} [$_serviceid])

Labels (2)
1 Reply
Vegar
MVP
MVP

Your expression  looks OK with one exception, you are missing a comma between the modifiers. Try this expression: 

 

count({<[visitreason2]={"*Survey*"} [eventdate] = {"<=$(=Today())"}} [$_serviceid])