Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is vMaxDate here?
This is a variable
=Date(Max([Link_Date]),'DD/MM/YYYY')
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