Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qlikviewaf
New Contributor III

Syntax MonthYear

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])

2 Replies
MVP
MVP

Re: Syntax MonthYear

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))

Re: Syntax MonthYear

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

MonthYear

Community Browser