topic Set expression incorrect in QlikView

Set expression incorrect

slribeiro — Fri, 23 Oct 2015 08:49:51 GMT

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

Re: Set expression incorrect

lironbaram — Fri, 23 Oct 2015 09:43:14 GMT

hi this seems right

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

Re: Set expression incorrect

sujeetsingh — Fri, 23 Oct 2015 09:45:14 GMT

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

Re: Set expression incorrect

Anonymous — Fri, 23 Oct 2015 09:47:03 GMT

try:

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

Re: Set expression incorrect

vishsaggi — Fri, 23 Oct 2015 09:47:27 GMT

Try this:

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

Thanks,

Re: Set expression incorrect

Gabriel — Fri, 23 Oct 2015 09:47:56 GMT

Hi,

Try this

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

Re: Set expression incorrect

vishsaggi — Fri, 23 Oct 2015 09:51:42 GMT

Sorry Missed this -> "<="

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