topic Re: Syntax problem Set Analysis in QlikView

Syntax problem Set Analysis

Anonymous — Wed, 29 Apr 2015 18:16:04 GMT

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 — Wed, 29 Apr 2015 18:19:04 GMT

Try this:

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

Anonymous — Wed, 29 Apr 2015 18:27:09 GMT

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

sunny_talwar — Wed, 29 Apr 2015 18:38:57 GMT

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

maxgro — Wed, 29 Apr 2015 18:41:45 GMT

what do you get for

=$(vAñoIndF)

in a text box?

NickHoff — Wed, 29 Apr 2015 18:43:33 GMT

Try using MaxString instead of SUM.

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

Anonymous — Wed, 29 Apr 2015 18:43:44 GMT

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 — Wed, 29 Apr 2015 20:00:16 GMT

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 — Wed, 29 Apr 2015 22:53:22 GMT

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