Function inside expression

[#1]

Hi. How can I use function inside a expression?

Works fine

Sum({<data_finalizado={'2015'}>}valor_total)

Is returning error

Sum({<year(data_finalizado)={'2015'}>}valor_total)

[sunny_talwar · Accepted solution]

Functions are not allowed within left hand side of set modifier. You can create year field in the script and use that

LOAD Year(data_finalizado) as Year

and then this...

Sum({<Year={'2015'}>}valor_total)

[#3]

Nice.

Thank You Sunny.

[sunny_talwar]

If it worked as you wanted, I would suggest you to close the thread by marking the correct response. If you still have doubts then please let us know

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny