Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Rostislav
Contributor
Contributor

Set expression on date

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"}

Labels (2)
1 Reply
Or
MVP
MVP

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