Error in Set Analysis

[Anonymous]

Hi,

can you please tell me where is the error in this set analysis, it says Expression OK, but still I can see the error sign.

I am trying to sum the values of the Previous month of the selected month.

This is my variable.

this is my raw data

[MK_QSL]

Use double quote instead of single quote..

i mean "$(....)"

[Anonymous]

Thank you... But Its not working.

[eromiyasimon]

its hard find the exact error using your screenshot, but i understand, you gave it like this just because of data confidentiality.

but what i can suggest is:

you need to close the no of curly braces that has been open and also you need close in the exact location, check and clear it.

OR

you can provide exact expression which causing errors.

[Anonymous]

Hi,

Please find the Expression attached.

[Anonymous]

The "Sale1" field is not red.

Does this field exist?

[rubenmarin]

Hi Anurang, I wrote similar expression and nothing is checked as an error, I'm using QV 12.0 SR4, maybe it's a syntax checker bug in your version.

[eromiyasimon]

i am not getting error for the above expression,

may be you can attach a sample data QVW

[jonathandienst]

There's no obvious cause of the error in what you have posted. So I think you need to provide more information.

It may not be the cause of your error, but why are using the the $1 set selector? If I remember correctly that selects the previous set of selections (not to be confused with the previous month), not the current set of selection (using the $ selector or no selector).

[stevedark]

There are lots of cases where the syntax highlighting gives incorrect feedback.

The first thing though, 1 and $ are mutually exclusive, one means whole data set and the other is current selection, together they make no sense.  You probably just want the $ symbol.

Also, I would remove the space after the set identifier ($ or 1), and if you still get an error put square brackets around the field name.

Hope that helps.

Steve