show values between dates

[#1]

Does anyone have a solution for counting a value which is valid between the start date and the end date. See the between date qvw.

I only want to count valid values within the selected YEARMONTH_PER field.

• count(distinct ID)if(DATE_PER > Startdate AND DATE_PER <= Enddate)

the syntax above is not working 😞

Hope someone has a solution or knows how to handle this kind of situations..

[#2]

Thanks for this excellent solution John! This is exaclty where I was looking for!

[biester]

Hi !

if(DATE_PER > Startdate,if(DATE_PER<Enddate,count(distinct ID),0),0)

HTH,

Martin