Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
MVP
MVP

Re: Howto: Count and filter based on date ?

May be this:

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

2 Replies
MVP
MVP

Re: Howto: Count and filter based on date ?

May be this:

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

Not applicable

Re: Howto: Count and filter based on date ?

Thanks !