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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Syntax problem Set Analysis

Hello QlikCommunity:

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

Syntax SetAnalysis.PNG

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!

8 Replies
sunny_talwar

Try this:

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

Anonymous
Not applicable
Author

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

Syntax SetAnalysis2.PNG

sunny_talwar

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

maxgro
MVP
MVP

what do you get for

=$(vAñoIndF)


in a text box?

NickHoff
Specialist
Specialist

Try using MaxString instead of SUM. 

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

Anonymous
Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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
Not applicable
Author

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