Syntax MonthYear

[qlikviewaf]

Hi Guys!

i have build the formula below that is working perfectly.

BTW i have to create another one where the SurgeryMonthYear should be the MonthYear minus 12 months. Anyone knows which is the right syntax?

Thanks!

=Sum({<SurgeryMonthYear={$(=concat(chr(39) & MonthYear & chr(39),',') )},MonthYear=,Day=,Year=,Month=,Quarter=>}[Surgical Procedures WI])

[swuehl]

You can use AddYears() / AddMonths() function to get the date one year ago.

AddYears(MonthYear,-1)

use a Date() or MonthName() format to get the same format required by your SurgeryMonthYear, e.g.

MonthName(AddYears(MonthYear,-1))

[sunny_talwar]

Did you checked out the suggestion from this thread of yours?

MonthYear