
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
More than one condition in expression
Hello,
I'm trying to count entities that fits selected daterange
Each entity record has StartDate and EndDate, I use Calendars to set vFromDate and vToDate
According to my meeds I need to Count entities that matches the criteria:
1) CloseDate > vFromDate
2) OpenDate < vToDate
I know how to write one of these two conditions:
=Count({$<OpenDate = {"<$(vToDate)"}>}EntityId)
but how to add the second condition there?
Updated:
Renamed StartDate to OpenDate
Renamed EndDate to CloseDate
- Tags:
- new_to_qlikview
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oh sorry, I read the post wrong the first time:
=Count({$<CloseDate = {">$(vFromDate)"}, OpenDate = {"<$(vToDate)"}>}EntityId)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Count({$<OpenDate = {">$(vFromDate)<$(vToDate)"}>}EntityId)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Something wrong here: where is the CloseDate?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oh sorry, I read the post wrong the first time:
=Count({$<CloseDate = {">$(vFromDate)"}, OpenDate = {"<$(vToDate)"}>}EntityId)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much!
