Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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?