topic Re: More than one condition in expression in QlikView

More than one condition in expression

Tue, 17 Dec 2013 16:23:47 GMT

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

Nicole-Smith — Tue, 17 Dec 2013 16:25:42 GMT

=Count({$<OpenDate = {">$(vFromDate)<$(vToDate)"}>}EntityId)

Tue, 17 Dec 2013 16:31:48 GMT

Something wrong here: where is the CloseDate?

Nicole-Smith — Tue, 17 Dec 2013 16:35:52 GMT

Oh sorry, I read the post wrong the first time:

=Count({$<CloseDate = {">$(vFromDate)"}, OpenDate = {"<$(vToDate)"}>}EntityId)

Tue, 17 Dec 2013 16:44:10 GMT

Thank you very much!