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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
zhbuyiqlik
Contributor II
Contributor II

Error: Garbage after expression

I created a pivot table that displays sales across different dimension.  I wanted to put the total sales on top of the sheet.  So I created a measure called Total Sales=Sum(Sales) and threw on to the top of the sheet.   The total is correct as I checked and it changes in response to all kinds of filtering.  But there is a message saying "Error: Garbage Over Expression" on the total Box. 

Don't know why.

Thanks

Message was edited by: Buyi Zhang

13 Replies
Digvijay_Singh
MVP
MVP

HI,

Can you share the expression you have in the title of this measure, looks like that has some problem. See the image below to identify the place I am talking about -

Capture.PNG

zhbuyiqlik
Contributor II
Contributor II
Author

My "Show Title" toggle was off.   The error persists when I tried to put title in.

zhbuyiqlik
Contributor II
Contributor II
Author

In the "Edit Measure" popup menu, Expression box, I only put in Sum(Sales) .  I tried your suggestion nevertheless--did not work.  Thanks

Digvijay_Singh
MVP
MVP

Can you share what is showing up in your title?