Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo Zusammen,
ich habe folgendes Problem mit folgender Formel:
sum( {$ <Jahr = {$(=Year(AddMonths((Today(1)),-12)))}, Monat = {$(=Month(AddMonths((Today(1)),-12)))} >} $(vMenge))
In Qlick Viw funktioniert diese Formel ohne Probleme, in Qlik Sense bekomme ich die Fehlermeldung " error in expression sum takes 1 parameter"
Im Forum habe ich nichts passendes gefunden.
This generated a valid expression
sum( {$ <Jahr = {$(=Year(AddMonths(Today(1),-12)))}, Monat = {$(=Month(AddMonths(Today(1),-12)))} >} $(vMenge))
Addmonths() needs 2 parameters you'd closed it off with. Also check what's in your variable for errors.
Thank you for your reply.
The error was in the variable. The error message was a bit misleading