12months rolling: error in expression

[TomBond77]

Hi experts

At which place the ")" is missing?

networkdays ( {$<[YearMonth]={">=$(=Monthstart([Event Date]), -11)"}>}, {$<[YearMonth]={"<=$(=MonthEnd([End Date]))"}>} )

[Oleg_Troyansky]

Hi Tom,

It depends on what was your intention about "-11" - is it a second parameter of the MonthStart date, or a simple subtraction?

If it's the second parameter, then the formula should look like this:

networkdays ( {$<[YearMonth]={">='$(=Monthstart([Event Date], -11))'"}>}, {$<[YearMonth]={"<=$(=MonthEnd([End Date]))"}>} )

I also added a pair of single quotes around the date calculation...

The other possibility doesn't make too much sense, so I wouldn't worry about it...

To learn advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!

[TomBond77]

Hi Oley

Your code is also not working.

I need to subtract 11 months from the event date. I am getting still the same error.

Regards, tom

[Oleg_Troyansky · Accepted solution]

Tom,

Please share a screenshot of the updated expression and the error, if you'd like anyone to be able to troubleshoot your issue. The more details you can provide, the better.

Cheers,