topic Re: Error in Set Analysis in QlikView

Error in Set Analysis

Anonymous — Wed, 23 Nov 2016 11:24:23 GMT

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

Re: Error in Set Analysis

MK_QSL — Wed, 23 Nov 2016 11:28:20 GMT

Use double quote instead of single quote..

i mean "$(....)"

Re: Error in Set Analysis

Anonymous — Wed, 23 Nov 2016 11:31:26 GMT

Thank you... But Its not working.

Re: Error in Set Analysis

eromiyasimon — Wed, 23 Nov 2016 11:35:27 GMT

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.

you can provide exact expression which causing errors.

Re: Error in Set Analysis

Anonymous — Wed, 23 Nov 2016 11:45:28 GMT

Hi,

Please find the Expression attached.

Re: Error in Set Analysis

Anonymous — Wed, 23 Nov 2016 11:49:33 GMT

The "Sale1" field is not red.

Does this field exist?

Re: Error in Set Analysis

rubenmarin — Wed, 23 Nov 2016 11:52:34 GMT

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.

Re: Error in Set Analysis

eromiyasimon — Wed, 23 Nov 2016 11:53:11 GMT

i am not getting error for the above expression,

may be you can attach a sample data QVW

Re: Error in Set Analysis

jonathandienst — Wed, 23 Nov 2016 12:06:54 GMT

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).

Re: Error in Set Analysis

stevedark — Wed, 23 Nov 2016 13:45:24 GMT

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