Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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