Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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)