last year count

[#1]

Hi all,

I am trying to get the last year count using below expression.

Last year:

count({$<CanonicalDate = {">=$(=Yearstart(Max(CanonicalDate),-1)) <= $(=YearEnd(Max(CanonicalDate),-1))"},

DateType= {'invitation'}>} invitation_id)

Present Year:

count({$<CanonicalDate = {">=$(=Yearstart(Max(CanonicalDate)))  <= $(=Date(Max(CanonicalDate)))"},

DateType= {'invitation'}>} invitation_id) 

With last year expression i am getting the count till today.

Please check and help.

Regards,

pramod

[Gysbert_Wassenaar]

I don't see anything obviously wrong. Can you post a Qlik Sense app (.qvf) that demonstrates the problem?

[#3]

please find qvf.

[#4]

I used below expression,

count({$<Year={$(=YEAR(TODAY())-1)}, DateType= {'invitation'}>} invitation_id)

I am getting the last year count,  I need to get count from particular date to end of the year.

For example:

from july 22 of 2014 to end of the year 2014.

I am declaring variable and assigned the date but how to take till end of the last year