Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Burgerking1975
Partner - Contributor
Partner - Contributor

error in expression sum takes 1 parameter

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.

Labels (3)
2 Replies
ogster1974
Partner - Master II
Partner - Master II

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.

Burgerking1975
Partner - Contributor
Partner - Contributor
Author

Thank you for your reply.

The error was in the variable. The error message was a bit misleading