Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Today(1) in "set modifier"

Hello,

I've got an issue I can't explain.

I use a set modifier to filter on the today date.

This works fine (with the good date)

=Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = {'22/11/2017'} > } [N°]  )

This doesn't work (when I wqnt to select the date of the day)

=Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = today(1) > } [N°]  )

I've got the message "Erreur dans l'expresssion" (in french) : "Error in expression"

What I am missing?

10 Replies
Anonymous
Not applicable
Author

Damn, You win

It works fine !!

How did you go to the conclusion to use the "floor"?