Syntax problem Set Analysis

[Anonymous]

Hello QlikCommunity:

I'm having a problem with the following a set Analysis syntax:

My variable is set like this:

=vAñoActual - 5

I can't figure what is the problem and how to fix it.

Thanks a lot!

[sunny_talwar]

Try this:

Sum({<year = {">=$(vAnoIndF)"}, name = {'A'}>} cited_references)

[Anonymous]

Still doesn't work, with the "", the script doesn't take the variable as such:

[sunny_talwar]

Would you be able to share a your app or a sample?

[maxgro]

what do you get for

=$(vAñoIndF)

in a text box?

[NickHoff]

Try using MaxString instead of SUM. 

MaxString({<year = {">=$(vAnoIndF)"}, name = {'A'}>} cited_references)

[Anonymous]

Hi,

you have to check that in the definition of your variables there is the uqual sign =

Then Sunidia's formula will work.

Elena

[ramoncova06]

in you variable does it start with a = or not ?

if is not using any = sign at the beginning then you have to use the $ expansion when calling your variable 

sum({<PriceDate = {">=$(=($(vAnoIndF)))"}name = {'A'}>}cited_references)

if it does have a "="

use it without the dollar expansion

sum({<PriceDate = {">=$(=((vAnoIndF)))"}name = {'A'}>}cited_references)

I also noticed you were missing the "=" before the variable

[Anonymous]

Sum({$<year = {">=$(vAnoIndF)"}, name = {'A'}>} cited_references)