Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
dwforest
Specialist II
Specialist II

Any row of data not have a numeric value for Sales?

zhbuyiqlik
Contributor II
Contributor II
Author

No, they are all numeric.

Thiago_Justen_

Make sure your Sales data is numeric. You can also try something like this:

Sum(Num#(Sales))

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
Thiago_Justen_

Could you please take a snapshot of the screen with expression?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
Anil_Babu_Samineni

Screenshot please?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zhbuyiqlik
Contributor II
Contributor II
Author

This did not work

zhbuyiqlik
Contributor II
Contributor II
Author

Top right corner

Qlik Sum.png

zhbuyiqlik
Contributor II
Contributor II
Author

Top right corner.  Thanks

Qlik Sum.png

Anonymous
Not applicable

If you are trying to start with a text concatenated with an expression you need to have it in this format:

="Total Sales = "&Sum(Sales)

That might fix the expression!