Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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

Can you share what is showing up in your title?