Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"}
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