Set expression on date

Rostislav — Wed, 28 Jul 2021 10:05:27 GMT

I need count workers in date range beetween 7/12/2021 and 7/26/2021.

I've tried:

count( {$<[workers.createdAt.autoCalendar.Date]={">=7/12/2021"}, [workers.createdAt.autoCalendar.Date]={"<=7/26/2021"} , reg_source={'android'}>} [workers._id])

But it does not consider this filter {">=7/12/2021"} only this one {"<=7/26/2021"}

Re: Set expression on date

Or — Wed, 28 Jul 2021 10:14:16 GMT

You'll need to write both conditions into the same section of the set analysis, otherwise one will overwrite the other.

See e.g.

https://community.qlik.com/t5/QlikView-App-Dev/range-with-set-analysis/td-p/252113

topic Re: Set expression on date in QlikView

Set expression on date

Re: Set expression on date