Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

qlikviewaf
Contributor

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

Highlighted

Re: Syntax MonthYear

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

MonthYear

Community Browser