Set Analysis

[ruma_barman]

Hi,

Can anybody help?The following script is not working for Month Name(This is field with format MMM YYYY)

Sum({<[Month Name]={">=$(=Date(AddMonths(vMaxDate,-2),'MMM YYYY'))<=$(=Date(AddMonths(vMaxDate,0),'MMM YYYY'))"}>} Data)

whereas it works for Link_Date(This is a field with format DD/MM/YYYY)

Sum({<Link_Date={">=$(=Date(AddMonths(vMaxDate,-2),'DD/MM/YYYY'))<=$(=Date(AddMonths(vMaxDate,0),'DD/MM/YYYY'))"}>} Data)

Thanks and Regards,

Ruma

[sunny_talwar]

What is vMaxDate here?

[ruma_barman]

This is a variable

=Date(Max([Link_Date]),'DD/MM/YYYY')

[sunny_talwar]

Don't see anything wrong in the expression... only thing to check is to make sure Month Name field is read as date and is not considered as string by QlikView