Count with a variable

[piekepotloed]

Hi to you all,

This is my data:

Person          Startdate       Enddate          CourseNumber

320 - mr. x     1-2-2013       15-12-2014        1

523 - mr. y     1-4-2013        23-7-2014         1

320 - mr. x     1-5-2014         1-1-2015          2   

234 - mrs. v     1-6-2014       1-7-2015          1  

varMaxDate = 1-10-2014

This is what I want:

Person                  ActiveCourses  

320 - mr. x               2

523 - mr. y               1

234 - mrs. v             1

This is te expression I use to count the Active Courses: ({$<Enddate={">=$(varMaxDate)"}>}Person)

And this is the result:

Person                  ActiveCourses  

320 - mr. x               0

523 - mr. y               0

234 - mrs. v             0

What's going wrong???

Thanks,

[tresesco]

PF attached qvw.

[#3]

Hi peter,

Try this for ActiveCourse,

count({$<EndDate={">=$(varMaxDate)"}>}Person)

[#4]

Hi Peter,

Use the below expression:

Count({$<Enddate={">=$(varMaxDate)"}>}CourseNumber)

Hope this helps.

Thanks

Sabal

[VishalWaghole]

Hi,

PFA Qvw application file it will help you.

-- Regards,

Vishal Waghole

[#6]

Peter I think you will also want to take into account the start date or you will end up counting courses which are not yet active

Count({$<Enddate={">=$(varMaxDate)"},Startdate={"<=$(varMaxDate)"}>}Person)