topic Re: Set Analysis Date Range in QlikView

Set Analysis Date Range

usamashahid — Tue, 13 Feb 2018 06:23:47 GMT

I'm trying to get count of employees who joined during specific dates. I've created date variables vStartDate and vEndDate. what ever I enter in the dates the count always shows zero. Please help, what am i doing wrong here.

Count({<STARTDATE = {">=$(vStartDate)<=$(vEndDate)"}>}EMPLID)

Re: Set Analysis Date Range

sunny_talwar — Tue, 13 Feb 2018 17:46:32 GMT

May be try one of these

1) Count({<STARTDATE = {">=$(=vStartDate)<=$(=vEndDate)"}>}EMPLID)

2) Count({<STARTDATE = {">=$(=$(vStartDate))<=$(=$(vEndDate))"}>}EMPLID)

Re: Set Analysis Date Range

usamashahid — Wed, 14 Feb 2018 05:23:30 GMT

Thank you Sunny for the response.

Unfortunately, both didn't work. I really can't figure out why it is not working.

Re: Set Analysis Date Range

sunny_talwar — Wed, 14 Feb 2018 17:24:39 GMT

Would you be able to share a sample where this is not working?