Why am I geeting the "Error in expression" message?

[brunolelli87]

Hello guys,

I'm working with the following expression and I believe it's correct, and providing the correct value for me, but Qlikview is saying there is an error in expression.

What am I doing wrong?

Thanks for your assistance,
Best regards

[sunny_talwar]

I think your date field is called PERI... you need to replace the word Date with PERI

[brunolelli87]

It's wierd, look at that!

Not the expression is ok, but the expression is not working...

[VishalWaghole]

Hi,

Please try this,

sum({=$(=Date(MonthStart(PERI,-12)),'DD/MM/YYYY') <=$(=Date(Max(PERI)))'}>} LOPP)

Please try to make same format of

Date or PERI, whatever is your dimension field. Thanks, Vishal Waghole

[brunolelli87]

Thanks for your assistance, but it's not working.
Please, take at look at the picture below:

[VishalWaghole]

After the opening curly bracket you have missed Date or PERI.

[sunny_talwar]

Try this

Sum({<PERI = {">=$(=Date(MonthStart(Max(PERI), -12)))<=$(=Date(Max(PERI)))"}>} LOPP)

[brunolelli87]

Your expression works "Expression OK", but the result is not what I'm expecting.

[brunolelli87]

Hello

Thanks for your help, but it's not working!
Would you mind to send me an example?

Thanks

[sunny_talwar]

What were you hoping to see?