topic Re: garbage after expression in QlikView

garbage after expression

Thu, 20 Aug 2015 16:15:51 GMT

Hello,

In qvw attached, when I am using straight table, then giving error, "Garbage after expression: )". But when I select pivot table, there is no error.

When I disabled second column in expression, then no error. Can anybody explain.

Re: garbage after expression

swuehl — Thu, 20 Aug 2015 16:26:05 GMT

Check your background color attribute expression of the Baseline Set expression, there is one closing bracket too many at the very end:

=if(IsContinuousDelivery=1, null(),

if([Valid Baseline Set]='NA',null(),if(sum(if([Valid Baseline Set] ='Yes' or [Valid Baseline Set]='No',1,0))>0,

if(sum(if([Valid Baseline Set]='Yes',1,0))=sum(if([Valid Baseline Set]='Yes' or [Valid Baseline Set]='No',1,0)) , RGB(0,150,0),RGB(250,0,0)),null())))

Re: garbage after expression

petter — Thu, 20 Aug 2015 16:28:04 GMT

If you check the "Baseline Set" expression in your Straight Table (the second expression) and have a look at the "Background Color" Definition you will find that it is one too many ending parantheses.

Once you remove that you will not get the "garbage after expression" error message...

Re: garbage after expression

Thu, 20 Aug 2015 16:29:21 GMT

Hi,

Thanks.

Two query:

1. How do you find this error, by checking the background colour or is there any other way to quick check this.

2. Why that error is not coming into pivot table.

Thanks

Re: garbage after expression

swuehl — Thu, 20 Aug 2015 16:39:03 GMT

1. You can check this in your chart properties, by disabling all expressions and then enable one after the other.

Then you have identified the buggy one. Chech the expression and all places where you can also use expressions (like for attribute modifications).

You can also go to Settings - Expression Overview, for few charts and expressions it's quite easy to find all relevant expressions in one place.

edit:

2. Ask Qlik, not me