Qlikview Count of ids in last 12 months in text object (box)

[matthewp]

I have two fields in my table Date & ID, i want to put in a text box the count of all the ids for the last 12 months.

This returns nothing:

=Num(count({$<DATE={'>=$(=AddMonths(Today(),-12))'}>}[ID]),'#,##0') 

This returns the correct count:

=count(ID) 

This returns the total for the year (2015):

SUM(IF( year(DATE) = year(today()),1,0))

[PrashantSangle]

Hi,

=Num(count({$<DATE={">=$(=AddMonths(Today(),-12))"}>}[ID]),'#,##0')

Regards,

Prashant

[sunny_talwar]

See if this works:

=Count({<DATE = {"$(='>=' & Date(AddMonths(Max(DATE), -12), 'YourDateFieldFormat') & '<=' & Date(Max(DATE), 'YourDateFieldFormat'))"}>} ID)

[kavita25]

Try this:

=Num(count({1<DATE={'>=$(=AddMonths(Today(),-12))'}>}[ID]),'#,##0')

[kavita25]

=Num(count({1<DATE={'>=$(=AddMonths(Today(),-12))'}>} ID),'#,##0')

[matthewp · Accepted solution]

This worked

=SUM(IF( (date(Monthname(DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))