garbage after expression

[#1]

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.

[swuehl · Accepted solution]

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

[petter]

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

[#4]

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

[swuehl]

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