Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nehapathak
Contributor II
Contributor II

Date comparision in Measure

I want to count the employees who have joined before 15/5/2017

what expression should be used for measure.

4 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

Try

Count({<YourFieldDate={"<=$(=Date('15/5/2017'))"}>}employees )

sunny_talwar

May be like this

Count(DISTINT {<DateField = {"$(='<=' & Date(MakeDate(2017, 5, 15), 'D/M/YYYY'))"}>} EmpID)

Anonymous
Not applicable

Something like

count(distinct if(JoinedDate<'15/5/2017', Employee))

Ivan_Bozov
Luminary
Luminary

Hello! You could use something like:

Count({<YourDateField={'<15/5/2017'}>}Distinct YourEmployeesField)

P.S. Seems like a lot of people were faster than me

vizmind.eu