Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
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)
Nice.
Thank You Sunny.
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