Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
usamashahid
Contributor II
Contributor II

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)

1 Solution

Accepted Solutions
sunny_talwar

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
sunny_talwar

May be try one of these

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

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

usamashahid
Contributor II
Contributor II
Author

Thank you Sunny for the response.

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

sunny_talwar

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