Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nehapathak
New 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
Honored Contributor

Re: Date comparision in Measure

Hi,

Try

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

MVP
MVP

Re: Date comparision in Measure

May be like this

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

mov
Esteemed Contributor III

Re: Date comparision in Measure

Something like

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

Ivan_Bozov
Valued Contributor

Re: Date comparision in Measure

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