Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
slribeiro
Partner - Creator
Partner - Creator

Set expression incorrect

Greetings, please take a look to the following expression:

Sum({$<Month= {"{<=$}(=Max(Month))"}, Year= {$(=max(Year))} } Value)

I want to calculate the sum of the values of all months till our selection from the current year, for example if our selection is april, i want to sum the values from jan, feb, mar, apr.

Regards, Simão Ribeiro

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Sorry Missed  this ->  "<="

Sum({$< Month = { "<=$(=Max(Month))" }, Year = { "$(=Max(Year))" }  >} Value)

View solution in original post

6 Replies
lironbaram
Partner - Master III
Partner - Master III

hi this seems right

Sum({$<Month= {"<=$(=Max(Month))"}, Year= {$(=max(Year))} } Value)

sujeetsingh
Master III
Master III

Sum({$<Month= {"<=$(=Max(Month))"}, Year= {"$(=max(Year))"} } Value)

Anonymous
Not applicable

Hi

try:

Sum({$<Month= {"<=$(=Max(Month))"}, Year= {"$(=max(Year))"} } Value )

vishsaggi
Champion III
Champion III

Try this:

Sum({$< Month = { $(=Max(Month)) }, Year = { $(=Max(Year)) }  >} Value)

Thanks,

V.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Try this

Sum({$<Month = {"<=$(=Max(Month))"}>}    Value)

vishsaggi
Champion III
Champion III

Sorry Missed  this ->  "<="

Sum({$< Month = { "<=$(=Max(Month))" }, Year = { "$(=Max(Year))" }  >} Value)