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: 
Not applicable

Howto: Count and filter based on date ?

I would like to make this statement below dynamic - using the today's date or even better - last date a data loading was made

is that possible?. I have tried with a few options using (today([timer_mode]) that I found in help. but I don't seem to get the syntax right...

Count({<TASK = {'Defect'}, LoadDate={'2016-01-04'}>} Priority)

1 Solution

Accepted Solutions
sunny_talwar

May be this:

=Count({<TASK = {'Defect'}, LoadDate = {"$(=Date(Floor(ReloadTime()), 'YYYY-MM-DD'))"}>} Priority)

View solution in original post

2 Replies
sunny_talwar

May be this:

=Count({<TASK = {'Defect'}, LoadDate = {"$(=Date(Floor(ReloadTime()), 'YYYY-MM-DD'))"}>} Priority)

Not applicable
Author

Thanks !