Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
usamahshahid
New Contributor

Set Analysis Date Range

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)

Tags (1)
1 Solution

Accepted Solutions

Re: Set Analysis Date Range

May be try one of these

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

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

View solution in original post

3 Replies

Re: Set Analysis Date Range

May be try one of these

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

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

View solution in original post

usamahshahid
New Contributor

Re: Set Analysis Date Range

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

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